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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
upturns926497(None) 
upturn8286241upturn_
inturns73210132inturns
outturns835912outturns
returns79712592returns
ruptures1056682ruptures
spurns84811382sp_urns
turns55623242__turns
upcurls1143652upcurls
uptorn8268092uptorn_
uptowns12194342uptowns
upturned11214012upturned
attorns738443attorns
auburns935573auburns
autumns943763autumns
bourns84114063_bourns
burns74926783__burns
captures1239443captures
churns114910233_churns
cothurns1344523cothurns
cultures10310153cultures
curns74924283__curns
daturas838783daturas
durns64819873__durns
externs1438233externs
futures10310263futures
interns73116773interns
inturn63411563inturn_
inurns63310983_inurns
kulturs1134723kultur_s
matures9314313matures
mourns84111013_mourns
multures1039333multures
natures7311963natures
nocturns1043733nocturns
nurtures837443nurtures
oppugns1241933oppugns
options93810603options
outburns1036063outburns
outruns72911543outruns
outturn737123outturn_
pirns76020093_p_irns
porns75527343_p_orns
pours74623183_pour_s
pterins9812993_pterins
puns66641483_p_u_ns
purins83722653_p_urins
puris75332023_p_uris
purls74723353_p_urls
purrs75320433_p_urrs
purs65641043_p_ur_s
putons83515153put_ons
raptures1037583raptures
return623222523return_
rupture966163ruptur_e
ruptured1144683ruptured
rupturing1244353rupturing
spurn74815453sp_urn_
spurs74621523sp_ur_s
spurts84814973sp_urts
sterns64616763_sterns
stuns54719493_stu_ns
sturts63915143_sturts
sunburns1044283sunburns
sutures7314223sutures
tarns56433953__tarns
terns55226873__terns
tuns45138663__tu_ns
turds65021693__turds
turfs84620443__turfs
turks95320823__turks
turn46330393__turn_
turps74918733__turps
ultras6310193ult_ras
unburnt977413unburnt
uncurbs1134913uncurbs
uncurls937123uncurls
unfurls1035573unfurls
untorn63012343untorn_
untruss736553untruss
untucks1334673untucks
untune62511603untu_ne
untunes72211253untunes
unturned9228563unturned
upborne11255133upborne
upcurl1034963upcur_l
upcurve1463273upcurve
upcurves1583153upcurves
updarts1034203updarts
upgirds11103073upgirds
uppers102912293upper_s
upstares10178583upstares
upstarts10165273upstarts
upstirs935293upstir_s
upsurge10134333upsurge
upsurges11144803upsurges
uptakes1336593uptakes
uptalks1333723uptalks
uptears9106453uptears
upthrew1542663upthrew
upthrow1543193upthrow
upthrows1643303upthrows
upthrust1343713upthrust
upticks1535153upticks
uptilts934733uptilts
uptimes1177553uptimes
uptore8279453uptor_e
uptoss836093upt_oss
uptown11274963uptown_
uptrend1044293uptrend
uptrends1142833uptrends
upturning1263373upturning
upwards13135963upwards
urns46323903___urns
usurps8105073u_surps
uterus639203u_terus
utters63817123utter_s
vultures1137213vultures

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271186.43620824.6
3Display Results1181180.0502360.0
 (SQL Overall)1786911186.89225927.3
 
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.