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

149 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
collaring1231056(None) 
cellaring1238531cellaring
collaging1337931collaging
collating12312781collating
clearing113014882c_learing
coleading1338522coleading
collapsing1543832collapsing
colleting12311062colleting
colliding1338582colliding
colluding1335902colluding
collying14319552coll_ying
coloring11414842co_loring
colouring1258732colouring
comparing162410582comparing
hollaing12167102holla_ing
hollering1337742hollering
pillaring1237652pillaring
pollarding1444242pollarding
allaying12339313_allaying
alluring939073_alluring
ashlaring1344493ashlaring
blaring104317113__blaring
blearing113111943_blearing
bolling103820883boll__ing
bollixing1944813bollixing
bolloxing1944773bolloxing
bullring11388423bull_ring
calling103826773call__ing
callusing1236173callusing
caring95137993c___aring
celling103921263cell__ing
charing133721323c__haring
chelating1549363chelating
clawing133812673c__lawing
claying133614303c__laying
cleaning113112383c_leaning
clearings12286063c_learings
clearwing1533673c_learwing
cleating113518143c_leating
cleaving141389683c_leaving
cloaking15299713c_loaking
closuring1255173closuring
cloturing1245473cloturing
clouring112811273c_louring
coaling103722823co__aling
coaming123818323co__aming
coating103525313co__ating
coaxing173511703co__axing
cochairing1844653cochairing
cockering1839693cockering
codling114418953codl__ing
coffering1838043coffering
coheading1636623coheading
cohering142413833co_hering
coiling103723453coil__ing
collagen11338583collagen_
collagens12256043collagens
collagist1248023collagist
collar83816173collar___
collarbone1452233collarbone
collard103712923collar__d
collards113310193collar_ds
collared113211143collar_ed
collaret103116703collar_et
collarets11327333collarets
collars93816573collar__s
collation11313993collation
collations12312853collations
collecting1548283collecting
colligating1545713colligating
collimating1645433collimating
collins93419833coll__ins
collocating1645913collocating
colloguing1444553colloguing
collyria1344823collyri_a
collyrium1643663collyrium
colocating1548623colocating
colorings1247683co_lorings
colubrine1345043colubrine
comaking1739993co_making
combating16310163combating
comparting17188383comparting
compering163414163compering
concaving1737353concaving
conflating16410003conflating
congaing1239823conga_ing
conjuring1937913conjuring
cooling103422573cool__ing
coopering142611323coopering
coppering162810893coppering
copulating1549373copulating
corelating13511583corelating
coring94433963co___ring
cornering12311893cornering
corrading1338203corrading
coshering15510023coshering
costarring1345393costarring
coumarin1247323coumarin_
coumarins1347023coumarins
covarying1844133co_varying
covering142215723co_vering
cowering142514033co_wering
cowling134017423cowl__ing
culling103921303cull__ing
cullying14297503cull_ying
culturing1236553culturing
declaring1339573declaring
decollating1545973decollating
dogearing1235763dogearing
dollarize1946193dollarize
dollarizing2254333dollarizing
dolling93817373doll__ing
dolloping1344993dolloping
dollying13407423doll_ying
fellating1339253fellating
flaring114116803__flaring
foliating1339253foliating
following1665753following
fullering1336653fullering
glaring93714883__glaring
holloaing1385803holloaing
holloing12148823holl_oing
hollooing1385363hollooing
hollowing1675933hollowing
jollying19316063joll_ying
lolling83415783loll__ing
lolloping1244693lolloping
moldering1367863moldering
mortaring1237943mortaring
oaring74225303_o__aring
pillaging1345573pillaging
poleaxing1944873poleaxing
polkaing1534633polka_ing
pollening1236923pollening
polling102920383poll__ing
polluting1235703polluting
roaring82916003ro__aring
rolling83620413roll__ing
scolloping1543243scolloping
soaring83521893so__aring
solacing11310133so_lacing
solating9315593so_lating
soldering1169033soldering
solvating1336443solvating
tallaging1146503tallaging
tillering1037883tillering
tolling83418563toll__ing
volleying1643763volleying
volplaning1642473volplaning

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.440406115.9
2DLD Change Limit1486411497.34320242.5
3Display Results1491490.0761960.5
 (SQL Overall)1786911497.85922737.1
 
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.