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

124 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
curve10492002(None) 
carve106227751carve
cure66149121cur_e
curie74533041curie
curse75829141curse
curved124815221curved
curves114619281curves
curvet114720241curvet
curvey144111841curvey
curvy136013371curvy
aurae54128112aurae
burke115122762burke
burse75527252burse
calve105919922calve
care66968372car_e
carle74535702carle
carse74934332carse
carte75940422carte
carved124320852carved
carvel114817572carvel
carven114716662carven
carver114420152carver
carves115128452carves
cave95941262c_ave
cere66741472cer_e
chive135117622chive
cire65836372cir_e
clave105420152clave
clove105619442clove
core67263112cor_e
corse75036182corse
corvee114320092corvee
corves115122522corves
corvet114626932corvet
course85117782course
cove95837072c_ove
crave105626312crave
crude86018572crude
cruse75726102cruse
cube85830212cu_be
cue57544182cu__e
cuke105824982cu_ke
culver113010632culver
cur56841982cur__
curare84916952curare
curate85226242curate
curb86732222cur_b
curbed114615872curbed
curber104517052curber
curbs94821652curbs
curch124415412curch
curd77634982cur_d
curded104217162curded
curdle95514312curdle
curds85725612curds
curdy115916522curdy
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curf97538782cur_f
curfew14426742curfew
curfs105122142curfs
curia74523772curia
curiae84518372curiae
curies84934022curies
curio74221212curio
curite85222942curite
curl66035052cur_l
curled95021652curled
curler85221322curler
curlew114010902curlew
curls74927102curls
curly105321232curly
curn66731892cur_n
curns74924282curns
curr65429652cur_r
curred94319262curred
currie84317262currie
currs75624392currs
curry105920342curry
curs65645542cur_s
cursed94321252cursed
curser84721472curser
curses85328272curses
cursive1237832cursive
curst74931022curst
curt67051712cur_t
curter85320082curter
curule83614122curule
curvets12399912curvets
curvier123110662curvier
cute66440452cu_te
cutie76925932cutie
cuvee10316142cuvee
decurve1335582decurve
dure56341812dur_e
furze176815812furze
gurge75419782gurge
incurve1236632incurve
lure45142462lur_e
mure65941332mur_e
murre74821072murre
nerve86617372nerve
nurse54420122nurse
ourie54027302ourie
parve109824852parve
pure65543332pur_e
puree74632842puree
purge85324602purge
purse76028892purse
purvey14559572purvey
recurve1237402recurve
scurvy14386102scurvy
serve85425962serve
suave83519872suave
sure45447412sur_e
surge65027692surge
survey124111672survey
turves94212692turves
upcurve1463272upcurve
urge54722422_urge
varve115716852varve
verve115417722verve

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 Filter178691538000.360496363.9
2DLD Change Limit538001243.00017933.3
3Display Results1241240.0631968.3
 (SQL Overall)1786911243.42352203.0
 
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.