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

107 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
spurt7722798(None) 
spirt75032951spirt
sport75935981sport
spur65321191spur_
spurn74815451spurn
spurs74621521spurs
spurts84814971spurts
sturt56028961sturt
apart74330672apart
aport75432172aport
blurt77625622blurt
court75532772court
curt67051712_curt
hurt77142572_hurt
part65967462_part
pert66759322_pert
port66059632_port
punt65747202_punt
pur56840552_pur_
pure65543332_pure
puri65931442_puri
purl65631422_purl
purr64925812_purr
purs65641042_purs
purty105019402_purty
put55759072_pu_t
putt66937842_putt
sault55834962sault
saury84317222saury
scart76139772scart
scurf104719322scurf
scut65835542scu_t
shirt84533902shirt
short85040532short
shunt85226512shunt
shut76137592shu_t
skirt95624662skirt
skort94925642skort
slur45525152slur_
slurb74116322slurb
slurp74014982slurp
slurs54123372slurs
slut45040592slu_t
smart75834092smart
smut66629782smu_t
snort54833752snort
sort46264812s_ort
sour45935892sour_
sours55230502sours
spait75631602spait
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spat66548522sp_at
spelt75430192spelt
spent75532832spent
sperm93216022sperm
spilt75532222spilt
spire75828692spire
spirit83519922spirit
spirts85317132spirts
spiry105017352spiry
spit65545082sp_it
splat76129342splat
split75729012split
spore75428592spore
sports84619182sports
sporty115112492sporty
spot65540692sp_ot
spout75029632spout
sprat76635972sprat
sprit76736402sprit
sprue74717632sprue
sprug85313892sprug
spry96819122sp_ry
spud75818492spu_d
spuds85113672spuds
spue66025522spu_e
spued84918472spued
spues75025382spues
spume95817312spume
spumy124610362spumy
spun66221462spu_n
spunk114513402spunk
spurge93711322spurge
spurns84811382spurns
spurry11429122spurry
spurted103111972spurted
spurter94013002spurter
spurtle937452spurtle
sputa74612962sputa
squat143720142squat
squirt153812932squirt
start55642312start
strut56030732strut
stunt55328172stunt
sturts63915142sturts
suet46754822s_uet
suit45649872s_uit
supra73614252supra
sura45740292s_ura
surd56433812s_urd
sure45447412s_ure
surf76039312s_urf
swart86234642swart
yurt76435042_yurt

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.313570897.8
2DLD Change Limit538001071.54634799.5
3Display Results1071070.0303566.7
 (SQL Overall)1786911071.88994595.6
 
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.