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

199 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
comrades1314977(None) 
comrade12139211comrade_
corrades111211261corrades
charades141310852charades
cockades1738432cockades
comade114415322com_ade_
comakes154413642com_akes
comates114123642com_ates
commodes1539092commodes
compadres16266412compadres
compares143816432compares
comradely1783482comradely
comradery1793492comradery
corrade101111042corrade_
corraded12128292corraded
corrodes111310332corrodes
courages11311392courages
couvades1435612couvades
pomades123711732pom_ades
abrades10312073_abrades
aggrades1135863aggrades
boraces113716853bo_races
borages103917163bo_rages
boranes93720403bo_ranes
borates94823013bo_rates
boraxes163511633bo_raxes
borides10515153bo_rides
cades85440733c___ades
camases114216343cam_ases
camisades1474963camisades
carafes125015703c_arafes
carates95630613c_arates
cascades13128553cascades
cerates95428253c_erates
chamades16138653chamades
charade13129913charade_
charases131312763charases
chorales133712883chorales
citrates102315093citrates
clades94920463c__lades
coaxes154715633co__axes
cobras104014193cobra__s
cockade1638133cockade_
cockaded1836393cockaded
cocreates132611883cocreates
codes86247293co___des
codrives1437663codrives
coerces11311943coer_ces
cognates11311583cognates
coheaded1536603coheaded
coheads13289233cohead_s
coinages11310803coinages
coleader1139183coleader
coleaders1237823coleaders
coleads102911423colead_s
collages113514243collages
collates103019143collates
collides113214473collides
colludes11279223colludes
comae97128423com_a_e_
comake144413423com_ake_
comaker153410603com_aker
comakers16339173com_akers
comanages1446533comanages
comas95833003com_a__s
comate104124843com_ate_
combated1539823combated
combater1439383combater
combaters1538113combaters
combats13311683comba_ts
combes125321733com__bes
combines142814623combines
comedies13311843comedies
comedos12329073com_edos
comes97246993com___es
comities12317793comities
commanded17136503commanded
commander16127403commander
commanders17146683commanders
commandoes17255263commandoes
commandos16245963commandos
commands15318823commands
commas124814573comma__s
commies133718453com_mies
commixes2177353commixes
commode1438123commode_
commoves1736963commoves
communes143411243communes
commutes143011893commutes
compacts16368903compacts
compadre15295883compadre
companies15311803companies
compare135814993compare_
compared153811823compared
comparer143611363comparer
comparers15319393comparers
comparts144210833comparts
compas125817063compa__s
compass13379563compa_ss
compasses1547393compasses
comperes143217973comperes
competes144117243competes
compiles14311983compiles
complies14314523complies
composes145017113composes
compotes144716513compotes
comprador1643593comprador
compradores1852603compradores
compradors1743783compradors
comprises15510943comprises
comprizes2468943comprizes
computes143914553computes
comraderies1653973comraderies
comradeship2162153comradeship
comtes106222813com__tes
concaves1538913concaves
concedes13311063concedes
confides14310573confides
coprahs14338153copra_hs
copras103517153copra__s
coracles121811163co_racles
corals85325143co_ra_ls
corbies113520123co_rbies
cordages12310113cordages
corded105923353co_r_ded
corder94322883co_r_der
corders104520883co_r_ders
cords86030623co_r_d_s
cores76361853co_r__es
corkages1539103corkages
corodies11313693co_rodies
corpses113913803co_rpses
corrals93713853corra_ls
corridas1177313corridas
corries94026793co_rries
corrode101310573corrode_
corroded12147513corroded
corrodies1247903corrodies
corsages11310363corsages
corses84433463co_r_ses
corvees124613793co_rvees
corves115122523co_r_ves
cottages113310493cottages
courage10310993courage_
courantes1148883courantes
courants10310803courants
courses94218893cour_ses
couvade1335063couvade_
covaries13413253covaries
coverages1538833coverages
cowages13310943co_wages
cowards1339613coward_s
cowbanes1537423cowbanes
cowhages1736113cowhages
cowhides1736013cowhides
cowries124218013cowr_ies
cowrites133011593cowrites
cradles103114133c__radles
crakes124921813c__rakes
cranes84330753c__ranes
crapes104727693c__rapes
crases85532313c__rases
crates85736063c__rates
craves115825393c__raves
crazes174720133c__razes
crudes96218623c__rudes
crusades1146333crusades
curares94916853c_urares
curates95323833c_urates
degrades11269923degrades
dolmades1245463dolmades
dorados938203do_rados
forages114217283fo_rages
formates132814293formates
forrader1236153forrader
gambades1435863gambades
gourdes9109383gour_des
grades84926313__grades
homages131011583hom_ages
hordes104921633ho_r_des
irades74517393__irades
joyrides1943853joyrides
limeades11116643limeades
monades103713823mo_nades
moorages1139053moorages
morales93619403mo_rales
nomads94711603nom_ad_s
noyades1136563no_yades
orates64328613_o_rates
parades104121463_parades
pomaces132712123pom_aces
pomade113611333pom_ade_
pomaded13377863pom_aded
regrades103212173regrades
roulades957173roulades
tirades8311723_tirades
torsades937213torsades
trades75724503__trades
upgrades12216063upgrades

Search took 8 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.440406115.9
2DLD Change Limit1461621996.89021213.6
3Display Results1991990.0762618.4
 (SQL Overall)1786911997.40624127.9
 
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.