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

176 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
collations1231285(None) 
collation11313991collation_
chelations1539072chelations
ciliations121111002ciliations
coalitions1247922coalitions
cognations1339592cognations
collating12312752collati_ng
collators11410342collat_ors
collections1547922collections
colligations1556832colligations
collimations1656872collimations
collisions1246322collisions
collocations1646392collocations
collodions1344592collodions
collusions1245972collusions
colorations13911872colorations
conations111318902co_nations
conflations16411142conflations
connations12312942connations
copulations151111102copulations
decollations1547352decollations
fellations1338062fellations
foliations1399942foliations
illations9311392_illations
lallations1038742lallations
oblations1139362_oblations
pollutions1245432pollutions
solations9814622so_lations
solvations1336832solvations
vallations1339082vallations
ablations11311503_ablations
acylations1547603acylations
adulations11310123adulations
alations82518893__alations
bolections14137283bolections
calculations1647073calculations
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
cations94524143c___ations
caudations13108223caudations
causations1268143causations
cessations1256473cessations
chalazions24113323chalazions
chelation1439963chelation_
ciliation111112493ciliation_
citations11312503c_itations
clarions10310493c__larions
clavations1546183clavations
coactions1349743co_actions
coagulations1546513coagulations
coalition1148703coalition_
coaptations1547533coaptations
cogitations1448903cogitations
cognation12310753cognation_
cognitions1346043cognitions
coitions10312853co__itions
colcannons1452043colcannons
colistins1149213colisti_ns
collagens12256033colla_gens
collaging1337913collagi_ng
collagists1345263collagists
collarbone1452233collarbone
collarbones1552103collarbones
collaring12310543collari_ng
collates103019143collat__es
collator10310373collat_o_r
collection1448203collection_
collegians1344423collegians
colleting12311053colleti_ng
colligation1457443colligation_
collimation1557573collimation_
collins93419833coll__i_ns
collision1146943collision_
collocation1547163collocation_
collodion1244983collodion_
collusion1146413collusion_
coloration12913183coloration_
commotions1686843commotions
compactions1946533compactions
companions1697263companions
compellations1954793compellations
compilations1848663compilations
completions1746903completions
conation101420883co_nation_
conditions13410103conditions
conflation15412083conflation_
congelations1549723congelations
connation11314263connation_
consolations1449723consolations
contagions1346603contagions
cooptions13107743co_options
copatrons1346333co_patrons
copulation141111953copulation_
coronations13410693coronations
corotations1349753corotations
corrasions1246353corrasions
correlations1447843correlations
creations112614543c_reations
cremations14410713cremations
crenations12511693crenations
cullions10219223cull__ions
cumulations1547433cumulations
cupellations1643803cupellations
dealations11311373dealations
decollation1448193decollation_
deflations1439713deflations
delations102616593_delations
dilations102614453_dilations
donations101112353do_nations
dotations101411633do_tations
elations83719123__elations
emulations12310943emulations
epilations12311713epilations
fellation1238843fellation_
fellatios1245503fellatio_s
filiations13119093filiations
flotations1366873flotations
foliation121110793foliation_
formations1538203formations
gelations102513093_gelations
halations12312393_halations
illation8311943_illation_
inflations13310323inflations
iodations1039113io_dations
isolations10310693isolations
lallation939493lallation_
lobations11219613lo_bations
lobulations1346203lobulations
locations112512743lo_cations
modulations14147263modulations
morulations13148163morulations
nodulations12147003nodulations
notations91512973no_tations
novations12139003no_vations
oblation1039863_oblation_
olfactions1563873_olfactions
orations81515803_o_rations
oscillations1445113oscillations
ovations11149263_o_vations
ovulations1337973ovulations
palliations1347723palliations
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
pollinations1447233pollinations
pollution1146003pollution_
populations15148713populations
potations111615063po_tations
pulsations1236373pulsations
reflations13311233reflations
relations92418333_relations
rogations101510823ro_gations
rotations91613843ro_tations
saltations10310623saltations
salvations1338133salvations
scalations1239783scalations
siltations1038553siltations
solation8916153so_lation_
solutions988883so_lutions
solvation1237773solvation_
spallations1356103spallations
spoliations1347693spoliations
sublations12410113sublations
sulcations1289583sulcations
sulfations13107813sulfations
tolerations1158113tolerations
ululations1037143ululations
vacillations1744853vacillations
vallation1239743vallation_
valuations1348783valuations
violations1337963violations
vocations141911423vo_cations
volitions1288663vo_litions
volutions12108393vo_lutions
zonations18139313zo_nations

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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031768.31316913.6
3Display Results1761760.0931892.5
 (SQL Overall)1786911768.56220870.2
 
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.