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 “arrester” 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.

153 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
arrester83925(None) 
arrested939151arrested
arrestee849431arrestee
arresters948191arresters
arrestor847641arrestor
arrest63722632arrest__
arrestees946232arrestees
arrestors958012arrestors
arrests73312682arrest_s
attester836502attester
barrister1145732barrister
forester11313672forester
harvester1544332harvester
prester93519622_prester
rester63832432__rester
wrester102812412_wrester
abetter958323a_better
abrupter1243793abrupter
absenter1086773absenter
accepter14144933accepter
addresser1143403addresser
adepter1036113a_depter
adjuster1644343adjuster
adroiter946183adroiter
affecter1644523affecter
agrestal945653agrestal
agrestic1147923agrestic
airest63825263airest__
alerter72111513a_lerter
ammeter1148393amme_ter
ancestor1046843ancestor
anteater8311603anteater
arbiter939933a_rbiter
arete56031353a_re_te_
aretes64425353a_re_tes
ariette7312373ariette_
ariettes8411353ariettes
armrest9310163armrest__
armrests1055373armrest_s
arouser74514423arous_er
arranger936873arranger
arrased8149863arras_ed
arrases71214543arras_es
arrayer10136703arr_ayer
arrear6310253arre__ar
arrestant947323arrestant
arresting1038633arresting
arrestive1246753arrestive
arrestment1246253arrestment
arrises71617583arris_es
arriver10117793arr_iver
artiste73813693artiste_
artistes83213343artistes
artsier768943a_rtsier
assenter867703assenter
asserter877563asserter
assister836753assister
aster55434893a___ster
attested936293attested
attesters935803attesters
attestor845463attestor
auguster943943auguster
aureate72515283aureate_
averter102410553a_verter
barrater10310143barr_ater
barrener1038333barre_ner
barretor1046713barre_tor
barrette1039783barrette_
barrettes1149063barrettes
barristers1244723barristers
bimester1236163bimester
burster9310293bur_ster
caresser1038803caresser
carpenter1346493carpenter
correcter1348103correcter
crested103416533_crested
detester9239683detester
diester83013683_diester
digester10258423digester
directer1137583directer
dopester1137253dopester
dragster1034623dragster
dresser83611953_dresser
erecter93113393_erecter
ester54727713___ester
ferreter1136543ferre_ter
fester94723513__fester
foreseer1139013foreseer
forested12312463forested
foresters12312533foresters
fresher132612643_fresher
fretter103412753_fretter
gamester1137323gamester
garreted1057523garre_ted
garroter956573garr_oter
greater84416493_greater
greeter82812673_greeter
grister83915413_grister
harvested1644093harvested
harvesters1644143harvesters
honester1139713honester
infester11239433infester
jester134319153__jester
jokester1934443jokester
keester11319913_keester
kiester11329973_kiester
marketer1437383marke_ter
modester1197483modester
molester1099373molester
narrater838723narr_ater
nester64124183__nester
orienter838313orienter
parroter1058203parr_oter
pester84827593__pester
presser93717623_presser
presters103419003_presters
priested1138393priested
protester111510483protester
quester161410023_quester
rarefier1135353rarefier
rarest65725483rarest__
raster64731443__raster
rearrested1145113rearrested
reenter73217793_reenter
reested82916233_reested
renter64527413__renter
rested74430783__rested
resters74130403__resters
rimester1037813rimester
roaster74116663_roaster
roister73516203_roister
rooster74415173_rooster
roster64329083__roster
rouster73517083_rouster
royster103110533_royster
semester1038903semester
tester64227153__tester
thresher1455823thresher
thruster1135793thruster
treater74219833_treater
trimester1145823trimester
truster73114313_truster
tryster10369513_tryster
unrested91914513unrested
ureter6313203_ure_ter
warranter1245193warranter
warrener1136913warre_ner
wester94222893__wester
wrested113410933_wrested
wresters112711733_wresters
wrestler11306993_wrestler
yester93417983__yester
zester153617793__zester

Search took 10 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 Filter1786911461620.186960704.3
2DLD Change Limit1461621538.81316584.8
3Display Results1531530.0632428.6
 (SQL Overall)1786911539.06219718.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.