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

185 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
fedoras113792(None) 
fedora1038591fedora_
federal1148532federal
federals1247302federals
femora1149582femora_
femoral1238722femoral
fetors91014472fetor_s
floras94715692f_loras
redowas1138392redowas
remoras9314072remoras
senoras72714952senoras
adores74420713_adores
adorns74212613_adorns
agoras7613343_agoras
angoras8811363angoras
ardors74416863ardor_s
auroras7311703auroras
bandoras1138743bandoras
bedsores1157633bedsores
begorah1355593begorah
bevors111610343bevor_s
beworms1437913beworms
bezoars1836793bezoars
boras75938303__boras
cedars93312833cedar_s
ceders93817673ceder_s
cedulas1058503cedulas
ceorls848163ce_orls
cesuras958683cesuras
decors94017773decor_s
deforms1337803deforms
dehorns11428363dehorns
dehorts11379773dehorts
deodaras1044693deodaras
deodars937623deodars
deports105012883deports
desorbs10437713desorbs
deworms1338013deworms
dhooras1135943dhooras
dobras94811913__dobras
donas65926473__donas
dopas85019063__dopas
dorks105724443__dorks
dorms85723833__dorms
dorps85419223__dorps
dorrs65520593__dorrs
dors56747603__dor_s
dorsa64617283__dorsa
douras75016723__douras
duras65727723__duras
edemas9310503_edemas
efforts1334703efforts
eras45441503_e__ras
extras13310223_extras
eyras84715923_e_yras
faders105117463fader_s
fados95620733fado__s
favors124211403favor_s
fears84829393fe_ar_s
federacy1744243federacy
federate12310873federate
federates13310143federates
fedexes1835473fedexes
feds85234313fed___s
feeders113712863feeder_s
feijoas1742323feijoas
fellas95116963fe_llas
felons93615763felo_ns
felworts1445953felworts
femurs1136713femur_s
fenders113717263fender_s
feodary1444713feodary
feods99516853fe_o_ds
feoffs1163703fe_offs
feral85424653fe__ral
ferals94216643fe__rals
feres86038183fe__res
ferias95020393fe_rias
ferns85220083fe__rns
ferrous1049793ferrous
ferulas103110753ferulas
fervors1336233fervor_s
fetas85624403fe__tas
fetor81214533fetor__
feuars938653feuar_s
fevers125414893fever_s
fidos95819053fido__s
fiords10498623f_iords
fjords17405353f_jords
flexors1734773flexor_s
floors94112353floor_s
flora85317103f_lora_
florae94713883f_lorae
floral94313813f_loral
florals104210063f_lorals
flotas94013003f_lotas
fluors94311373fluor_s
foetors1039753foetor_s
fora75937393f__ora_
foram105124933f__oram
forams115115913f__orams
foray115023973f__oray
forays124813003f__orays
forbs105720803f__orbs
fords95328183f__ords
fores85847103f__ores
forks125324683f__orks
forms105327053f__orms
forts86034453f__orts
furores10310033furores
furors9310953furor_s
genoas74013623geno_as
heders104119763heder_s
hegiras1136103hegiras
hejiras1744233hejiras
horas86333093__horas
hydras13239313hyd_ras
ixoras1337193_ixoras
judokas1992453judokas
koras95927113__koras
madras94316423mad_ras
medakas1435763medakas
medias93620783med_ias
medinas103411463medinas
medlars10259443medlars
medusas1036213medusas
menorah1247933menorah
menorahs1346543menorahs
moras76438763__moras
mudras94212253mud_ras
odors64514273_odor_s
oedemas1056693oedemas
pakoras1337473pakoras
pandoras11310053pandoras
pederast1158593pederast
pedlars103210213pedlars
pedocal1237893pedocal
pedocals1346083pedocals
pedros9312183ped_ros
pelorias10410583pelorias
pelorus939273pelorus
pelotas9410723pelotas
peroral9314793peroral
readorns938273readorns
rebores95319163rebores
records105213923records
recorks134813023recorks
redears82814453redears
redias74523603red_ias
redocks14409933redocks
redoes74623753redo_es
redons75222183redo_ns
redos65126763redo__s
redouts81411653redouts
redowa1038453redowa_
redoxes15310883redoxes
redraw10269853red_raw
redraws11218473red_raws
reforms1239813reforms
remora8414583remora_
reports94916213reports
resorbs95010523resorbs
resorts74817193resorts
retorts76016513retorts
rewords115413973rewords
reworks145113593reworks
rhodoras1244453rhodoras
seders74420283seder_s
senhoras11278283senhoras
senora63216153senora_
senores73218113senores
senors63620783senor_s
serosas7312663serosas
soras55041013__soras
sudoral8148543sudoral
sudors7311093sudor_s
tenors63217753tenor_s
tephras1236283tephras
terras63516953te_rras
tetras63017613te_tras
toras55540373__toras
vendors113510223vendor_s
weldors11238003weldor_s
zebras1737853ze_bras
zedoary2043213zedoary

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271859.04614816.2
3Display Results1851850.0632936.5
 (SQL Overall)1786911859.26519286.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.