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

158 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
spur6532119(None) 
pur56840551_pur
slur45525151slur
sour45935891sour
spar65433301spar
spud75818491spud
spue66025521spue
spun66221461spun
spurn74815451spurn
spurs74621521spurs
spurt77227981spurt
aper66336232aper
asper75520432asper
blur66020532blur
bur55744692_bur
cur56841982_cur
dour56330432dour
four76226862four
fur66637322_fur
gaur56723352gaur
hour75827312hour
knur85311982knur
lour45430682lour
opus66420592opus
our36042892_our
par57467022_par
per56353092_per
pour611527472pour
pub76037692_pub
pud65836662_pud
pug65337182_pug
pul56138062_pul
pun58846512_pun
pup76339882_pup
pure65543332_pure
puri65931442_puri
purl65631422_purl
purr64925812_purr
purs65641042_purs
pus55547842_pus
put55759072_put
sapor75119252sapor
sapour83812382sapour
sau36356572sau_
saul45836522saul
saury84317222saury
scar66434202scar
scaur75814912scaur
scour75315532scour
scud76221282scud
scum85924522scum
scup84822382scup
scurf104719322scurf
scut65835542scut
sear47353842sear
seer45547042seer
ser36752402s_er
shul75823152shul
shun75122772shun
shut76137592shut
sieur5911892sieur
sir35746682s_ir
skua86113152skua
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slurb74116322slurb
slurp74014982slurp
slurs54123372slurs
slut45040592slut
smug75815262smug
smut66629782smut
snub65320762snub
snug55218692snug
soar46838672soar
sopor74016492sopor
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sours55230502sours
sous46947212sous
spa55730812sp_a
spae65034322spae
spam85930042spam
span65234662span
spare75135562spare
spark114920892spark
spars75431542spars
spas67036722spas
spat66548522spat
spay96631662spay
spaz155626162spaz
spear75821062spear
spec85821972spec
sped76031492sped
speer74623902speer
speir75315362speir
sperm93216022sperm
spew95421872spew
spic85227432spic
spier75728032spier
spik105419712spik
spin66231302spin
spire75828692spire
spirt75032952spirt
spiry105017352spiry
spit65545082spit
spiv95917792spiv
spoor75016352spoor
spore75428592spore
sport75935982sport
spot65540692spot
spout75029632spout
sprue74717632sprue
sprug85313892sprug
spry96819122spry
spuds85113672spuds
spued84918472spued
spues75025382spues
spume95817312spume
spumy124610362spumy
spunk114513402spunk
spurge93711322spurge
spurns84811382spurns
spurry11429122spurry
spurts84814972spurts
sputa74612962sputa
spy86023742sp_y
star48037762star
stir45723252stir
stour54916742stour
stub66221842stub
stud56220092stud
stum65526022stum
stun45623452stun
sturt56028962sturt
sub55445552s_ub
sue35651462s_ue
suer45334032suer
suk75632972s_uk
sum56346012s_um
sun37149032s_un
sup57041942s_up
supe65932762supe
super74924482super
supra73614252supra
sups64834432sups
suq126228992s_uq
sura45740292s_ura
surd56433812s_urd
sure45447412s_ure
surf76039312s_urf
swum96416822swum
tour45530382tour
waur76819902waur
your78623432your

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 Filter178691298720.546327272.9
2DLD Change Limit298721581.70317540.8
3Display Results1581580.0762078.9
 (SQL Overall)1786911582.32576856.3
 
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.