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 “spurn” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
spurn7481545(None) 
spun66221461spu_n
spur65321191spur_
spurns84811381spurns
spurs74621521spurs
spurt77227981spurt
bourn75518482bourn
burn65636432_burn
churn105113102churn
curn66731892_curn
durn56127632_durn
inurn53712862inurn
mourn77215012mourn
pirn67128372_pirn
porn65636022_porn
pun58846512_pu_n
pur56840552_pur_
pure65543332_pure
puri65931442_puri
purin75527592_purin
purl65631422_purl
purr64925812_purr
purs65641042_purs
saury84317222saury
scorn75817452scorn
scurf104719322scurf
sharn84823702sharn
shorn85722182shorn
shuln84713112shuln
shun75122772shu_n
slur45525152slur_
slurb74116322slurb
slurp74014982slurp
slurs54123372slurs
sorn46641062s_orn
sour45935892sour_
sours55230502sours
span65234662sp_an
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spawn107811712spawn
spean74620512spean
sperm93216022sperm
spin66231302sp_in
spire75828692spire
spirt75032952spirt
spiry105017352spiry
spoon74719442spoon
spore75428592spore
sport75935982sport
sprue74717632sprue
sprug85313892sprug
sprung94610032sprung
spry96819122sp_ry
spud75818492spu_d
spuds85113672spuds
spue66025522spu_e
spued84918472spued
spues75025382spues
spuing94313362spuing
spume95817312spume
spumy124610362spumy
spunk114513402spunk
spurge93711322spurge
spurned10339262spurned
spurner9269652spurner
spurry11429122spurry
spurts84814972spurts
sputa74612962sputa
stern55319122stern
stun45623452stu_n
sturt56028962sturt
sun37149032s_u_n
sunn45423592s_unn
supra73614252supra
sura45740292s_ura
surd56433812s_urd
sure45447412s_ure
surf76039312s_urf
sworn86115312sworn
turn46330392_turn
upturn8286242upturn
urn35731472__urn
yourn87512772yourn

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 Limit53800861.47036598.6
3Display Results86860.0165375.0
 (SQL Overall)178691861.79999328.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.