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

117 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
collaging133793(None) 
collaring12310561collaring
collating12312781collating
cellaring1238532cellaring
coleading1338522coleading
collagen11338582collagen_
collagens12256042collagens
collagist1248022collagist
collapsing1543832collapsing
colleting12311062colleting
colliding1338582colliding
colloguing1444552colloguing
colluding1335902colluding
collying14319552coll_ying
hollaing12167102holla_ing
pillaging1345572pillaging
tallaging1146502tallaging
allaying12339313_allaying
alleging1038473_alleging
bolling103820883boll__ing
bollixing1944813bollixing
bolloxing1944773bolloxing
cabbaging1744093cabbaging
caging105321023c___aging
calling103826773call__ing
callusing1236173callusing
celling103921263cell__ing
chelating1549363chelating
clagging13328883c_lagging
clanging124012123c_langing
clawing133812673c__lawing
claying133614303c__laying
cleaning113112383c_leaning
clearing113014883c_learing
cleating113518143c_leating
cleaving141389683c_leaving
clinging122910913c_linging
cloaking15299713c_loaking
clogging13368503c_logging
coaling103722823co__aling
coaming123818323co__aming
coating103525313co__ating
coaxing173511703co__axing
codling114418953codl__ing
cogging123513713co__gging
coheading1636623coheading
coiling103723453coil__ing
collage102813763collag__e
collaged12279973collag_ed
collages113514243collag_es
collagists1345263collagists
collation11313993collation
collations12312853collations
collecting1548283collecting
collegia1146063collegi_a
collegial1245733collegial
collegian1245043collegian
collegians1344423collegians
collegium1444383collegium
colligating1545713colligating
collimating1645433collimating
collins93419833coll__ins
collocating1645913collocating
colocating1548623colocating
coloring11414843co_loring
colouring1258733colouring
comaking1739993co_making
comanaging1644323comanaging
combating16310163combating
comparing162410583comparing
concaving1737353concaving
conflating16410003conflating
congaing1239823conga_ing
cooling103422573cool__ing
copulating1549373copulating
corelating13511583corelating
corrading1338203corrading
cowling134017423cowl__ing
culling103921303cull__ing
cullying14297503cull_ying
decollating1545973decollating
dolling93817373doll__ing
dolloping1344993dolloping
dollying13407423doll_ying
fellating1339253fellating
foliating1339253foliating
following1665753following
foraging1358063fo_raging
hollering1337743hollering
holloaing1385803holloaing
holloing12148823holl_oing
hollooing1385363hollooing
hollowing1675933hollowing
homaging1536613ho_maging
jollying19316063joll_ying
lolling83415783loll__ing
lolloping1244693lolloping
montaging1346543montaging
obliging1236103_obliging
pillaring1237653pillaring
poleaxing1944873poleaxing
polkaing1534633polka_ing
pollarding1444243pollarding
pollening1236923pollening
polling102920383poll__ing
polluting1235703polluting
portaging1346843portaging
rolling83620413roll__ing
salvaging1465283salvaging
scolloping1543243scolloping
solacing11310133so_lacing
solating9315593so_lating
solvating1336443solvating
tolling83418563toll__ing
volleying1643763volleying
volplaning1642473volplaning
voyaging1632563vo_yaging

Search took 10 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.423422437.4
2DLD Change Limit1486411179.09316346.8
3Display Results1171170.0631857.1
 (SQL Overall)1786911179.57918654.5
 
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.