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 “nurds” 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
nurds6551852(None) 
burds84626061burds
curds85725611curds
hurds95219071hurds
nards65928461nards
nerds65719251nerds
nurd56224341nurd_
nurls55519681nurls
surds65624661surds
turds65021691turds
urds55922431_urds
auras55932562auras
aures55137092aures
auris55331532auris
bards87139642bards
birds85421332birds
buds75235172bu_ds
bunds85523542bunds
buras74736302buras
burbs95423492burbs
burd75534262burd_
burgs84924092burgs
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
cards85137932cards
cords86030622cords
cruds85815852cruds
cuds76730472cu_ds
curbs94821652curbs
curd77634982curd_
curdy115916522curdy
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cur_s
duads76515342duads
duds65530142du_ds
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
enures63919712enures
euros54920242euros
fards96629842fards
fords95328182fords
fuds86528562fu_ds
funds94119252funds
furls85322052furls
furs76735042fur_s
girds74816992girds
gourds8108252gourds
guards84611572guards
guids75516152guids
gurus64318192gurus
hards96435652hards
herds96424682herds
hurls86522712hurls
hurts86922822hurts
inures63318952inures
inurns63310982inurns
knurls10396242knurls
knurs94511152knur_s
kurus98015632kurus
lards65331862lards
lords64923502lords
lures56138532lures
lurks95218742lurks
muds75530652mu_ds
muras75329582muras
mures75937222mures
murids93212192murids
murks114821732murks
murrs75521302murrs
narcs76122022narcs
nard56634452nard_
nares55544152nares
naris55735292naris
narks96026032narks
needs65719632needs
nerd56624942nerd_
nerdy95014702nerdy
nerts55924982nerts
nods55838222n_ods
noris54928272noris
norms76019312norms
nubs65927142nu_bs
nude56626272nu_de
nudes64723292nudes
nukes95418122nukes
nulls55019982nulls
numbs94913092numbs
nuns45228232nu_ns
nurl45327242nur_l
nurse54420122nurse
nurses63919352nurses
nus37939392nu__s
nuts45032672nu_ts
ouds56430102ou_ds
ours47237562our_s
pards85634332pards
puds75630512pu_ds
purda82914692purda
purdas92612262purdas
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
quads154515842quads
quids154917462quids
quods154610222quods
rudds74811702rudds
sards64736182sards
sords64527802sords
sudds75513592sudds
suds56135292su_ds
suras55336332suras
surd56433812surd_
surfs85022542surfs
turd56027622turd_
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
urbs65922062_urbs
urd46427052_urd_
urns46323902_urns
urps66920482_urps
urus46426142_urus
wards97734402wards
words95425072words
yards95324612yards
yirds96612512yirds
yurts87216532yurts

Search took 2 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.326548131.9
2DLD Change Limit538001391.40638264.6
3Display Results1391390.0334212.1
 (SQL Overall)1786911391.765101241.4
 
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.