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

221 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
consider1131039(None) 
confider1438121confider
considers1238931considers
candider1237342candider
collider113410412collider
conceder1338732conceder
conciser12310242conciser
confide13310202confide_
confided1537452confided
confiders1537482confiders
confides14310572confides
confiner13311192confiner
conifer123212642con_ifer
conniver1337492conniver
considered1444282considered
consigner1246632consigner
consoler102812612consoler
conspirer1355292conspirer
consumer1238502consumer
cosier84423752co_si_er
insider849732_insider
onside7511802_onside_
reconsider1344532reconsider
sonsier7711742sonsi_er
topsider1144502topsider
bonder95324783bon__der
bonier84321993bon_i_er
bonnier94711313bonni_er
bossier93712423bossi_er
canister101710853canister
cannier94014163canni_er
censer84516583cens__er
censurer10228133censurer
chider125116053c__hider
choosier1337163choosi_er
cider84723313c___ider
cinder94119123cin__der
coalier93416173coali_er
coaster94219033coas_ter
cobbier133410163cobbi_er
cockier154013623cocki_er
codder104416333co__dder
coder86134213co___der
codriver1435903codriver
coesite9713623coesite_
coesites101313093coesites
cognizer2055863cognizer
coholder1436063coholder
coiler84421593co__iler
coincide1346493coincide_
coincided1544023coincided
coincides1446423coincides
coiner84323783co__iner
coinsurer1144763coinsurer
colander1139033colander
colder95121833co__lder
coleader1139173coleader
collide103214783collide_
collided12309793collided
colliders12298073colliders
collides113214463collides
collier93618153colli_er
colluder11276863colluder
combiner14259723combiner
comfier1439163comfi_er
compiler1438373compiler
concede12310093concede_
conceded1438283conceded
conceders1437953conceders
concedes13311053concedes
conceiver1657413conceiver
concise11314473concise_
concluder1444173concluder
condoler113412113condoler
condoner112913403condoner
condor94616963con__dor
conducer13127363conducer
confer114018683con__fer
confident1549383confident
confine12315583confine_
confined14310403confined
confiners1439953confiners
confines13315653confines
confirmer1665663confirmer
confiteor1443873confiteor
confuter1338503confuter
congener112412203congener
conger95024273con__ger
conidia1069303con_idia
conies84338593con_i_es
conifers133611703con_ifers
coniine9316803coniine_
coniines10415363coniines
conine84528553con_ine_
conines93827793con_ines
conjoiner1855933conjoiner
conjurer17117673conjurer
conker124721553con__ker
conner84423963con__ner
connive1238993connive_
connived1436433connived
connivers1436933connivers
connivery1744213connivery
connives1339723connives
conoid9818883conoid__
conoidal1149003conoidal
conoids10813883conoid_s
conquer1838613con_quer
consenter11312493consenter
conserver1448723conserver
considerate1455473considerate
considering1544843considering
consign1038773consi_gn
consigned1346323consigned
consignee1246563consignee
consigners1346413consigners
consignor1244103consignor
consigns1137533consigns
consist9316033consi_st
consisted1238503consisted
consists10310593consists
console92715983console_
consoled112911443consoled
consolers112510923consolers
consoles103216153consoles
conspire1257873conspire_
conspired1445663conspired
conspirers1444573conspirers
conspires1358483conspires
construer1146903construer
consular1038813consular
consulter1198223consulter
consume11510133consume_
consumed1337923consumed
consumers1337203consumers
consumes12310413consumes
container11311073container
contender1239563contender
continuer1148713continuer
contriver1448333contriver
convener132913163convener
conveyer16278143conveyer
convincer1645833convincer
convoker17226903convoker
copier103722893co_pi_er
corder94322873co__rder
corkier133114303corki_er
cornier93017083corni_er
corridor1145033corridor
cosher114819903co_s_her
cosie74728263co_si_e_
cosied94819883co_si_ed
cosies84932153co_si_es
cosigner1135953co_signer
cosine83823513co_sine_
cosines94122673co_sines
coster84331293co_s_ter
cottier93814173cotti_er
courier93617873couri_er
cowhide1636133cowhide_
cowhided1843743cowhided
cowhides1735993cowhides
cowier113616163co_wi_er
cowriter13238883cowriter
cozier173315143co_zi_er
crosier94116573crosi_er
crusader1144263crusader
curseder1145343curseder
donniker1333923donniker
donsie7613643donsi_e_
dossier83711693dossi_er
downside1345293downside_
downsides1444813downsides
fonder104120063fon__der
goosier83512563goosi_er
gorsier83811073gorsi_er
gossiper1164203gossiper
horrider1236523horrider
horsier103013243horsi_er
hosier94219613ho_si_er
inside7613453_inside_
insiders947753_insiders
insides8512653_insides
ionizer162310123ion_izer
ironside945853ironside_
ironsides1045293ironsides
joyrider1942663joyrider
lopsided1244253lopsided
lousier72411623lousi_er
lowrider1234153lowrider
moniker1338673mon_iker
monsieur1043313monsieur
monster93214593mons_ter
mossier94413813mossi_er
mousier93712463mousi_er
noisier759453noisi_er
nonsigner1045363nonsigner
nonskier1235983nonskier
nosier63716323no_si_er
osier53518013_o_si_er
outsider9269643outsider
ponder94521693pon__der
presider11410423presider
reconsiders1443183reconsiders
resider84615803_resider
rosier64221263ro_si_er
snider74413913_sn_ider
solider82912453so_lider
sonder73623523son__der
sonsie6614853sonsi_e_
subsider1138243subsider
tonier65520713ton_i_er
tonsilar843953tonsilar
topside1037733topside_
topsiders1243013topsiders
topsides1137203topsides
torrider936163torrider
voider103611553vo__ider
wonder103617813won__der
wonkier1437423wonki_er
yonder103214133yon__der

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.1561145455.1
2DLD Change Limit1461622216.81321453.4
3Display Results2212210.0902455.6
 (SQL Overall)1786912217.05925313.9
 
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.