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

153 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
curler8522132(None) 
burler84723831burler
culler84322251culler
curber104517051curber
curdler103511561curdler
curer75030751cur_er
curled95021651curled
curlers94218071curlers
curlew114010901curlew
curlier93314181curlier
curser84721471curser
curter85320081curter
cutler84718031cutler
furler93616401furler
hurler94717221hurler
birler85715082birler
bugler94717722bugler
burbler114412422burbler
burger94020792burger
burier84324652burier
burker125221172burker
burled94825382burled
burlers94120272burlers
burley114715752burley
burlier93514412burlier
burner83819202burner
burrer83718472burrer
butler84220032butler
cabler104519172cabler
caller85125482caller
carder94524182carder
career85822242career
carer74942332car_er
carle74535702carle_
carles85435082carles
caroler93816752caroler
carper104923632carper
carter84932272carter
carver114420152carver
ceiler84013962ceiler
choler113717152choler
churner12298342churner
circler1136422circler
coaler84121712coaler
coiler84421592coiler
cooler84824712cooler
corder94322882corder
corer75538872cor_er
corker124720852corker
corner84625622corner
coruler9311712coruler
coupler114713012coupler
courier93617892courier
courser94114802courser
courter94516482courter
crier74724462c_rier
cruder95612382cruder
crueler939022crueler
cruller968752cruller
cuber95222532cu_ber
cuddler113810742cuddler
culet76040342cu_let
culex144613932cu_lex
culled94022472culled
cullers93418852cullers
cullet84727312cullet
culver113010632culver
cumber124016702cumber
cummer124414592cummer
cunner83915002cunner
cupeler1177482cupeler
cupper124313862cupper
curare84916952curare
curbed114615872curbed
curbers115514382curbers
curded104217162curded
curdier103312622curdier
curdle95514312curdle_
curdled113910662curdled
curdlers11368492curdlers
curdles103814572curdles
cure66149122cur_e_
cured85932132cur_ed
curers84923192cur_ers
cures75645432cur_es
curet75447642cur_et
curfew14426742curfew
curie74533042curie_
curies84934022curies
curl66035052curl__
curlews12387392curlews
curls74927102curl_s
curly105321232curl_y
curr65429652cur__r
curred94319262curred
currier93316702currier
curse75829142curse_
cursed94321252cursed
cursers94317162cursers
curses85328272curses
cursor84110292cursor
curule83614122curule_
curve104920022curve_
curved124815222curved
curves114619282curves
curvet114720242curvet
curvey144111842curvey
curvier123110662curvier
cusser86016092cusser
cuter74728232cu_ter
cutlers94217002cutlers
cutlery12448392cutlery
cutlet84924362cutlet
cutter84521002cutter
cycler1335912cycler
dueler74213682dueler
duller74017702duller
fueler94313932fueler
fuller94220382fuller
furled104717052furled
furlers104214222furlers
huller93919102huller
hurdler113610002hurdler
hurled104617452hurled
hurlers103714322hurlers
hurley125012522hurley
hurter93915852hurter
luller63415482luller
lurer54625312lur_er
lurker103613292lurker
muller83820352muller
murder93613782murder
murker123715242murker
nurled74016232nurled
nurser64314502nurser
puler74826622pu_ler
puller83820812puller
purer75127902pur_er
purfler12248732purfler
purger94717232purger
purled94520752purled
purpler11289272purpler
purser85020472purser
ruler54923342ru_ler
sculler99812152sculler
surer54833102sur_er
surfer93515882surfer
surger74320092surger
surlier72915442surlier
sutler63718392sutler
turner63914612turner
turtler72610322turtler
urger64116472_urger

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 Filter178691825510.596299817.1
2DLD Change Limit825511532.59331836.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911533.23555236.8
 
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.