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 “curling” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

139 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
curling10432018(None) 
burling104421131burling
carling103727061carling
culling103921301culling
curbing123814021curbing
curding113515131curding
curdling12228891curdling
curing94824781cur_ing
curlings114110381curlings
curring103616841curring
cursing104217031cursing
curving133912101curving
furling114016561furling
hurling113616411hurling
nurling84215821nurling
purling103620291purling
birling104317052birling
bugling113615342bugling
bulling104324792bulling
burbling13249422burbling
burgling12239302burgling
burking143716322burking
burning104215502burning
burping124012942burping
burring104016992burring
burying133413912burying
butling103516812butling
byrling13337372byrling
cabling124017552cabling
calling103826772calling
carding113922442carding
caring95137992car_ing
carking144322852carking
carlin84421822carlin_
carline93923622carline
carlings114015862carlings
carlins93921922carlins
caroling113317002caroling
carping123521082carping
carting104228282carting
carving133916772carving
catling104819792catling
ceiling103416722ceiling
celling103921262celling
cering94522532cer_ing
churning14237172churning
churring14298652churring
circling1338422circling
cling86424672c__ling
coaling103722822coaling
codling114418952codling
coiling103723452coiling
cooling103422572cooling
cording113620822cording
coring94433962cor_ing
corking143018822corking
corning103720132corning
coupling13310782coupling
coursing113112022coursing
courting112514572courting
cowling134017422cowling
crying123612282c_rying
cubing114213952cu_bing
cuddling13287652cuddling
cueing94913612cu_eing
cuffing163210252cuffing
cuing85420192cu__ing
cullying14297502cullying
culming123811182culming
cunning104214622cunning
cupeling1338862cupeling
cupping144312382cupping
curating11314292curating
curbings13407312curbings
curlier93314182curlier
curlily1238382curlily
currying14196492currying
cussing103814272cussing
cutline92914542cutline
cutting103817492cutting
cuttling1138202cuttling
cycling1537212cycling
cymling1536272cymling
darling93418362darling
dirling93316072dirling
dueling93614542dueling
dulling93418272dulling
during84419402dur_ing
durning93511732durning
fueling113615132fueling
fugling124212512fugling
fulling114019702fulling
furlong11295412furlong
furring114013142furring
guiling93214212guiling
gulling94019562gulling
gurging102910112gurging
gurgling11267322gurgling
hulling113619012hulling
hurdling13288012hurdling
hurlings12388212hurlings
hurting113914032hurting
hurtling12318312hurtling
jurying18337762jurying
knurling1344942knurling
lulling83616802lulling
luring73820752lur_ing
lurking123710852lurking
marling103322772marling
muling93519882mu_ling
mulling103819992mulling
muring95120372mur_ing
nulling83818062nulling
nursing84012552nursing
nursling997602nursling
parling103823762parling
puling93621402pu_ling
pulling103821072pulling
purfling1467762purfling
purging113314182purging
purlin83615862purlin_
purline93516532purline
purlings113910282purlings
purlins93415422purlins
purpling1368542purpling
purring104515822purring
pursing103715552pursing
ruling73219552ru_ling
sculling112910992sculling
surfing112914482surfing
surging93115432surging
tirling83315732tirling
turfing113010052turfing
turning83713182turning
turtling9238832turtling
uncurling1237112uncurling
upcurling1453492upcurling
urging83413122_urging
urping93914052_urping

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711393.48330913.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911393.92245561.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.