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

134 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
collinses113828(None) 
collapses1344682collapses
collides113214472colli_des
collies94326582colli__es
collins93419832collin__s
collinsia11123782collinsia
collinsias12143892collinsias
colonises112814012colonises
coulisses1145632coulisses
cullises103111312culli_ses
jolliness1636212jolliness
pollinoses12144992pollinoses
bollixes1747203bolli_xes
bowlines133211623bowlin_es
calcines12314753calcin_es
calcinoses1445123calcinoses
callings113613833callin_gs
calliopes1346143calliopes
callipees1345303callipees
calloses10313393call_oses
callouses1147683callouses
calluses1039323call_uses
carlines103521643carlin_es
cellists1038563celli_sts
challises14358783challi_ses
chilliness1555313chilliness
cholines132214493cholin_es
cleanses10358143c_leanses
clines84926043c__lin_es
coalifies1439113coalifies
cocaines121314443cocain_es
cockiness17248783cockiness
codeines113114523codein_es
codlings123110103codlin_gs
codlins104116243codlin__s
cognises11610043cogni_ses
coldness1137953co_ldness
coleuses1039723co_leuses
colicines13311203colicin_es
colies84837053co_li__es
colins85229043co_lin__s
colitises11311743colitises
collages113514243coll_ages
collapse1244273collapse_
collapsed1443223collapsed
collates103019143coll_ates
colleges112410523coll_eges
collide103214793colli_de_
collided12309803colli_ded
collider113410423colli_der
colliders12298073colliders
collie83621993colli__e_
collied103316673colli__ed
collier93618153colli__er
collieries1248333collieries
colliers103613583colli_ers
colligates1347713colligates
collimates1447973collimates
collinear1144113collinear
collogues1246213collogues
colludes11279223coll_udes
colobuses1346133colobuses
colognes11310603cologn_es
colones96124433co_lon_es
colonies103620013co_lonies
colonise102514283colonise_
colonised12248723colonised
colonists112512503colonists
colonizes202613183colonizes
colpitises1445743colpitises
combines142814623combin_es
comeliness1446993comeliness
comfiness1646953comfiness
complines15312833complin_es
condenses12710133condenses
confines13315653confin_es
coniines10415363coniin_es
conines93827793co_nin_es
conioses10313313co_nioses
continues11310993continues
convinces1647833convinces
coolies93824963cooli__es
coolness1037743cool_ness
coprinces1547483coprinces
corallines1246553corallin_es
corkiness152810443corkiness
corniness112611183corniness
cosines94122673co_sin_es
cosiness103214283co_siness
costliness1245993costliness
coulisse1045113coulisse_
covellines1545303covellin_es
cowlings14359783cowlin_gs
coziness19319823co_ziness
cullies94419963culli__es
curliness1138553curliness
cutlines102413273cutlin_es
dollies83620983dolli__es
ellipses1044343_ellipses
follicles1444103follicles
follies103618943folli__es
godliness1136593godliness
hilliness1248923hilliness
holiness112512503ho_liness
hollies103420813holli__es
hotlines11811643hotlin_es
jollies143516273jolli__es
jollifies1945553jollifies
jollinesses1836723jollinesses
jollities1647873jollities
jowliness1934853jowliness
lollies73116923lolli__es
lowliness1236403lowliness
millines102718063millin_es
moldiness12227053moldiness
mollies93420233molli__es
mollifies1447553mollifies
oiliness8311563_oiliness
oleines7313393_olein_es
pollenoses12144813pollenoses
pollices12410753polli_ces
pollinates1247303pollinates
pollinizes2146953pollinizes
pollinosis1283653pollinosis
pollists10910823polli_sts
potlines10714213potlin_es
rollings9419953rollin_gs
scolioses1155613sco_lioses
silliness9510363silliness
tallises82713263talli_ses
toplines102412563toplin_es
towlines112610343towlin_es
wooliness12147693wooliness
woolliness1343563woolliness

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 Filter1786911486410.1601116818.8
2DLD Change Limit1486411347.26320465.5
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.48623870.0
 
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.