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

172 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
curter8532008(None) 
carter84932271carter
courter94516481courter
curber104517051curber
curer75030751cur_er
curler85221321curler
curser84721471curser
cuter74728231cu_ter
cutter84521001cutter
hurter93915851hurter
acuter84412862acu_ter
barter85525382barter
blurter9419832blurter
bunter85020382bunter
burger94020792burger
burier84324652burier
burker125221172burker
burler84723832burler
burner83819202burner
burrer83718472burrer
burster9310292burster
buster84726492buster
butter84724232butter
canter85230112canter
carder94524182carder
career85822242career
carer74942332car_er
carper104923632carper
carte75940422carte_
carted98631442carted
cartel85022532cartel
carters95327262carters
cartes86239472cartes
carver114420152carver
caster85232572caster
cater74840722c_ater
center84421412center
certes84623082certes
charter123918302charter
chunter123911482chunter
churner12298342churner
citer74827332c_iter
cluster94013332cluster
clutter94211662clutter
coater84329572coater
colter84625092colter
cooter85128612cooter
copter109822012copter
corder94322882corder
corer75538872cor_er
corker124720852corker
corner84625622corner
cortex15311472cortex
coster84331292coster
cotter84926672cotter
coulter94115602coulter
counter94220152counter
courier93617892courier
courser94114802courser
courted103514922courted
courters103015372courters
courtier1059332courtier
couter84930222couter
crater85026642crater
crier74724462c_rier
cruder95612382cruder
cuber95222532cu_ber
culler84322252culler
culver113010632culver
cumber124016702cumber
cummer124414592cummer
cunner83915002cunner
cupper124313862cupper
curare84916952curare
curate85226242curate_
curated104717582curated
curates95323832curates
curator9312212curator
curbed114615872curbed
curbers115514382curbers
curded104217162curded
curdier103312622curdier
curdler103511562curdler
cure66149122cur_e_
cured85932132cur_ed
curers84923192cur_ers
cures75645432cur_es
curet75447642cur_et
curets84922342curets
curfew14426742curfew
curie74533042curie_
curies84934022curies
curite85222942curite_
curites93919862curites
curled95021652curled
curlers94218072curlers
curlew114010902curlew
curlier93314182curlier
curr65429652cur__r
curred94319262curred
currier93316702currier
curse75829142curse_
cursed94321252cursed
cursers94317162cursers
curses85328272curses
cursor84110292cursor
curt67051712curt__
curtal83914542curtal
curtest9713962curtest
curtesy1265832curtesy
curtly1149282curtly
curtsey1255012curtsey
curtsy1156642curtsy
curve104920022curve_
curved124815222curved
curves114619282curves
curvet114720242curvet
curvey144111842curvey
curvier123110662curvier
cusser86016092cusser
cute66440452cu_te_
cutes79438322cu_tes
cutey105819792cu_tey
cutler84718032cutler
cutters94218962cutters
darter75320362darter
duster74919722duster
furler93616402furler
further1337002further
garter74420512garter
gutter73817712gutter
hunter94817772hunter
hurler94717222hurler
hurters103413652hurters
juster134617012juster
lurer54625312lur_er
lurker103613292lurker
luster64023672luster
murder93613782murder
murker123715242murker
murther1237952murther
muster84724522muster
muter74525542mu_ter
mutter84418882mutter
nurser64314502nurser
nutter63918052nutter
ouster64223732ouster
outer55633302ou_ter
perter84422282perter
porter84224412porter
punter84320032punter
purer75127902pur_er
purger94717232purger
purser85020472purser
purtier93214092purtier
putter83921442putter
quarter163211862quarter
quoter153510092quoter
scutter93512172scutter
sorter64425092sorter
spurter94013002spurter
suiter64121812suiter
surer54833102sur_er
surfer93515882surfer
surger74320092surger
tarter64023562tarter
tufter9319932tufter
turner63914612turner
turtler72610322turtler
ureter6313202_ureter
urger64116472_urger
utter54218762_utter

Search took 3 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.360496363.9
2DLD Change Limit825511722.34335233.0
3Display Results1721720.0463739.1
 (SQL Overall)1786911722.74965002.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.