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

154 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
consigns113753(None) 
consign1038771consign_
cosigns1047511co_signs
codesigns1353662codesigns
coigns94410062co__igns
condign1147732condign_
conins84327232con_i_ns
consigned1346322consigned
consignee1246562consignee
consignees1345222consignees
consigner1246632consigner
consigners1346412consigners
consignor1244112consignor
consignors1344302consignors
consists10310592consists
coreigns1136322coreigns
cosign958782co_sign_
cousins9516002cousi_ns
ensigns836352_ensigns
reconsigns1344412reconsigns
assigns836193_assigns
bondings12369413bondings
cannings113710333cannings
casings104013513c_asings
censing104215263censi_ng
cessions1039853cessions
chasings14318253chasings
clonings11307433clon_ings
closings11277673closings
coamings13349293coamings
coastings12357863coastings
coatings113811843coatings
cocains111313923cocai_ns
cochins141413103cochi_ns
codeins103715483codei_ns
codesign1274503codesign_
codlings123110103codlings
codlins104116243codli_ns
coesites101313093coesites
coffins153110193coffi_ns
cohesions1447093cohesions
coign85013913co__ign_
coigne94612193co__igne
coignes103912153co__ignes
coins75834553co__i_ns
coitions10312853coitions
cojoins1638993cojoi_ns
colins85229043co_li_ns
collins93419833colli_ns
combings15348323combings
comings124013533co_mings
conations111318903conations
concerns122710833concerns
concisions1448243concisions
condemns1336293condemns
condignly1644033condignly
confides14310573confides
confine12315583confi_ne
confines13315653confines
confirms1536303confirms
confits122811423confi_ts
confusions1546303confusions
congas94417033con__gas
conges94928173con__ges
congius103210073congi_us
congos94219883con__gos
conics103920593con_i_cs
conies84338593con_i_es
coniine9316803con_iine
coniines10415363coniines
conin76232723con_i_n_
conine84528553con_i_ne
conines93827793con_ines
coning94331823con_i_ng
coniums11311863con_iums
conjoins1738133conjoins
conking143618453conki_ng
conning103718753conni_ng
connives1339723connives
conns75024233con___ns
conoids10813883conoi_ds
conquians2045183conquians
conscious1347593conscious
consent93723113cons_ent
consents102715893consents
consider11310393consider
considers1238933considers
consigning1446783consigning
consist9316033consi_st
consoles103216153consoles
consols92914073cons_ols
consorts101512343consorts
conspires1358483conspires
constant10515593constant
constants11410913constants
consuls92412313cons_uls
consults10219983consults
consumes12310413consumes
contains10316533contains
contemns1237403contemns
contusions1246993contusions
convicts15337713convicts
cookings15358603cookings
coonskins1544183coonskins
copings124111843co_pings
cordings123011363cordings
coreign1037343coreign_
corsages11310363corsages
cortins92421333corti_ns
cosies84932153co_si_es
cosigned1235723co_signed
cosigner1135953co_signer
cosigners1245133co_signers
cosine83823513co_si_ne
cosines94122673co_sines
countians1147333countians
coursings12235873coursings
cousin8517163cousi_n_
covings134511243co_vings
covins114618063co_vi_ns
cowlings14359783cowlings
cowskins1745263cowskins
crossings12217163crossings
cunnings11357343cunnings
designs9328313_designs
ensign737523_ensign_
eosins64419163eo_si_ns
housings12307483housings
insigne837673_insigne
longings10408563longings
losings82810623lo_sings
mansions1069793mansions
monsignor1252353monsignor
monsignors1352613monsignors
monsoons1047343monsoons
mousings11277703mousings
nonsigner1045363nonsigner
nonsigners1145143nonsigners
nosings8349593no_sings
onions64016433_on_ions
opsins8411713_opsi_ns
pensions10311693pensions
reconsign1245243reconsign_
resigns83910963_resigns
rinsings9318013rinsings
ronions73313343ron_ions
rosins64521863ro_si_ns
scansions1145323scansions
signs65516323___signs
sponsions1145223sponsions
tensions8310223tensions
tocsins939963tocsi_ns
tonsils7310183tonsi_ls
torsions839183torsions

Search took 9 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.420425454.8
2DLD Change Limit1461621547.51619446.8
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.99922339.2
 
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.