Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “agorot” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

227 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
agorot741500(None) 
agoroth1145141agoroth
abort76133582abor_t
afoot8420112afo_ot
aggro738012aggro_
aggros836552aggros
agora6914332agor_a
agorae7511202agorae
agoras7613342agoras
amort75832202amor_t
aport75432172apor_t
grot55942052_g_rot
torot56139942_torot
abbot9318453a_bbot
aboon74918703abo_on
aboral8314373aboral
aborts84916183aborts
about75229083abo_ut
acorn75616623acor_n
acorns85013013acorns
adobo84711593adobo_
adobos9438453adobos
adopt81219743ado_pt
adore65723673ador_e
adored84714243adored
adorer74713453adorer
adores74420723adores
adorn64917093ador_n
adorns74212613adorns
adroit7518793adroit
aero45435343a_ero_
affront1357963affront
afore85818603afor_e
afrit8323173a_frit
agar58726413agar__
agaric93513633agaric
agarose838673agarose
agars66120643agar_s
ageist7315383ageist
agent65829643ag_ent
ager55935843ager__
agers65027853ager_s
aggadot1045183aggadot
aghast105711373aghast
agio57828453ag_io_
agios65919863ag_ios
agist66325583ag_ist
aglet65534143ag_let
aglow94711973ag_low
ago48845523ag__o_
agog68019003ag__og
agon56531883ag__on
agonal7410053agonal
agone65924553ago_ne
agones75719863agones
agonic93515143agonic
agonist82615403agonist
agons66423783ago_ns
agony96415653ago_ny
agouti7388773agouti
agouty10366913agouty
agree65226033ag_ree
agria65517143ag_ria
ahorse9311513ahorse
aigret73720023aigret
airt45757783a_ir_t
alert54740653aler_t
algor6513053algor__
algors7312553algor_s
aliyot93611713aliyot
allot54933873a_llot
aloft8423433alo_ft
aloof83521573alo_of
amoral8314633amoral
amorist9317643amorist
amoroso946093amoroso
amorous9311133amorous
amount8414483amount
andro6314163andro_
andros7313303andros
angora71111573angor_a
angoras8811363angoras
anoint6423633anoint
anorak1038923anorak
aorist64827873a_orist
aorta55922573a_orta
apart74330673apar_t
apolog938903apolog
aporia8315863aporia
apron7318833a_pron
argot67728653a_rgot
aroint6328153aroint
aroynt9312893aroynt
arrow83414883a_rrow
art38679143a__r_t
ascot76522513a_scot
assort64916383assor_t
attrit6315753attrit
avert86029493aver_t
avocet11412683avocet
avoset9315673avoset
axolotl1443353axolotl
bhoot104322103bho_ot
boot67759373_bo_ot
boron76727143_boron
bort65960963_bor_t
cahoot11416473caho_ot
carrot8423123carrot
cavort11316173cavor_t
cloot76127053clo_ot
coot67860383_co_ot
dogtrot947443dogtrot
egoist7612283egoist
egret63327313eg_ret
enroot6615993enroot
faggot1139053fag_got
fagot9323403fag__ot
floret9321123floret
foot76248013_fo_ot
forgot104318133_forgot
fort76456443_for_t
galiot72322593galiot
galoot72719163galoot
garote7717953_garote
garret74426553garret
garron73113493garron
garrote8510103garrote
gavot9321123_gavot
gemot84024233_gemot
gigot74023073_gigot
giro55828633_giro_
giron66118993_giron
giros65722653_giros
girt56646423_gir_t
goat56250833_go_at
gobo76126903_gobo_
gobos86219383_gobos
godet7530043_godet
gogo69722833_gogo_
gogos77516523_gogos
gonof95218653_gonof
goo47754773_go_o_
good66531803_go_od
goof85436873_go_of
gook96429603_go_ok
goon57236173_go_on
goop75829483_go_op
goos57644913_go_os
gor47848263_gor__
goral65125753_goral
gore55744963_gor_e
gored75227083_gored
gores65740373_gores
gorge76423893_gorge
gorget87123863_gorget
gorgon8310243_gorgon
gorm75529393_gor_m
gorms85619593_gorms
gorp75625903_gor_p
gorps85316993_gorps
gorse65926813_gorse
gorsy95915783_gorsy
gory86129663_gor_y
got49870443_g__ot
gout56646003_go_ut
grat55651283_g_rat
griot65328413_griot
grit55247243_g_rit
groat65531973_groat
grog65923343_g_rog
grok95819683_g_rok
groom85317983_groom
grots65025853_g_rots
grout65330423_grout
grow86127303_g_row
guyot9314523_guyot
gyro85217883_gyro_
gyron95314623_gyron
gyros95616483_gyros
haftorot1445773haftorot
hoot75752103_ho_ot
horst85833513_horst
korat94934433_korat
lagoon7410483lago_on
lirot5430033_lirot
loot46955823_lo_ot
maggot10311713mag_got
magot8326393mag__ot
moot67653623_mo_ot
moron76925423_moron
mort66758833_mor_t
oot311274693__o_ot
ort39465233__or_t
parrot8320663parrot
pogrom1138593pogrom
port66059633_por_t
ragout7317183rago_ut
ragwort11510743ragwor_t
robot7325973_robot
root45655923_ro_ot
rot37282953___rot
scoot75729153sco_ot
shoot84235913sho_ot
short85040533shor_t
skort94925643skor_t
snoot55030143sno_ot
snort54833753snor_t
soot45761063_so_ot
sort46264813_sor_t
sport75935983spor_t
taboret92916113taboret
taproot9412673taproot
tarot55943933_tarot
thoro86217873thoro_
thoron94713903thoron
toot45958883_to_ot
toro48045683_toro_
toros54336193_toros
toroth95512963_toroth
tort46967463_tor_t
trot46351313__trot
unroot6315553unroot
uproot8314123uproot
vagrom1235943vag_rom
whort114623693whor_t
worst86330133_worst
wort76654753_wor_t

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.436409841.7
2DLD Change Limit1127162275.90619085.0
3Display Results2272270.0633603.2
 (SQL Overall)1786912276.40527898.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.