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

109 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
nurse5442012(None) 
burse75527251burse
curse75829141curse
nursed74514671nursed
nurser64314501nurser
nurses63919351nurses
purse76028891purse
arse46539272_arse
aurae54128112aurae
aures55137092aures
birse74517402birse
bourse84414332bourse
burke115122762burke
burs65847422burs_
bursa74921522bursa
bursae84515602bursae
burses84425512burses
burst75332242burst
carse74934332carse
corse75036182corse
course85117782course
cruse75726102cruse
cure66149122cur_e
cures75645432cures
curie74533042curie
curs65645542curs_
cursed94321252cursed
curser84721472curser
curses85328272curses
curst74931022curst
curve104920022curve
druse64817662druse
dulse65415042dulse
dure56341812dur_e
dures65635922dures
durst66125172durst
enure53520222enur_e
enures63919712enures
furs76735042furs_
furze176815812furze
fuse76429992fu_se
gorse65926812gorse
guise64717712guise
gurge75419782gurge
gursh94512332gursh
horse86132652horse
hurst85527192hurst
inure54119052inur_e
inures63318952inures
knurs94511152knurs_
lure45142462lur_e
lures56138532lures
marse76231152marse
morse76032702morse
mure65941332mur_e
mures75937222mures
murre74821072murre
muse67136032mu_se
nares55544152nares
nerve86617372nerve
noise55723732noise
noose55624062noose
nose46739362n_ose
nubs65927142nubs_
nude56626272nu_de
nudes64723292nudes
nudge74616432nudge
nudie65118672nudie
nuke85920752nu_ke
nukes95418122nukes
nuns45228232nuns_
nurd56224342nur_d
nurds65518522nurds
nurl45327242nur_l
nurled74016232nurled
nurls55519682nurls
nursers74311832nursers
nursery10396022nursery
nus37939392nu_s_
nuts45032672nuts_
nutsy85711502nutsy
ourie54027302ourie
ours47237562ours_
parse75236992parse
perse75429522perse
pulse74219972pulse
pure65543332pur_e
puree74632842puree
purge85324602purge
purs65641042purs_
pursed95220882pursed
purser85020472purser
purses84826372purses
pursue84512252pursue
pursy105016412pursy
qursh174110842qursh
ruse45938932ru_se
sure45447412sur_e
surge65027692surge
terse55026822terse
torse55833332torse
urase54624692_urase
urge54722422_urge
ursa44116912_ursa
ursae55214452_ursae
use36835162_u_se
verse84723582verse
worse86525262worse
wurst85122992wurst

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 Filter178691538000.343520965.0
2DLD Change Limit538001091.65632487.9
3Display Results1091090.0303633.3
 (SQL Overall)1786911092.02988068.5
 
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.