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

109 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
runty8611904(None) 
aunty85919811aunty
punty106021611punty
runny84613481runny
runt46647991runt_
runts55927631runts
rusty85221051rusty
rutty85617801rutty
aunt46553652aunt_
auntly95211062auntly
aunts55227632aunts
banty106624002banty
bounty113411072bounty
brunt75728752brunt_
brunts85215452brunts
bunny104715802bunny
bunt65850852bunt_
bunts75729802bunts
busty105621012busty
butty104020112butty
canty105226802canty
county114313322county
crusty114911342crusty
cunt66243672cunt_
cunts76125122cunts
cutty105417222cutty
dungy104713642dungy
dunt55746872dunt_
dunts65828412dunts
dusty96018332dusty
duty85321452du_ty
fruity12429702fruity
funky154315132funky
funny114614832funny
fusty115016522fusty
grungy11345972grungy
grunt65523542grunt_
grunts75511852grunts
gunky135514112gunky
gunny94413662gunny
gusty95119572gusty
gutty94516992gutty
hunky155417732hunky
hunt76445492hunt_
hunts86826172hunts
janty156816962janty
jaunty16388512jaunty
junky194513232junky
junta123713672junta
junto125114562junto
jutty154914642jutty
linty87126562linty
lunt46148842lunt_
lunts55826902lunts
luny77324132lun_y
lusty85417572lusty
minty106323902minty
musty105620952musty
nutty84816872nutty
panty105929302panty
punky144419392punky
punny104217712punny
punt65747202punt_
punto75121322punto
punts75828002punts
puny95526992pun_y
purty105019402purty
putty104721402putty
randy95022082randy
rangy95320392rangy
rant45864682rant_
rants55935342rants
ratty84819592ratty
rent46661242rent_
rente54733782rente
rents55935182rents
rindy95717402rindy
rooty86423022rooty
rubby124413862rubby
ruby97819942ru_by
ruddy104511752ruddy
rugby11448132rugby
ruly76323142ru_ly
rummy124212412rummy
run36244992run__
rune45236302run_e
runes55530222runes
rung56429982run_g
rungs611819402rungs
runic73615772runic
runs46438082run_s
runway12105972runway
rushy115414812rushy
rust45544912rust_
rusts55026992rusts
rut35560522ru_t_
ruth76825992ru_th
ruts44541492ru_ts
suety85318492suety
sunny84917742sunny
tenty86121602tenty
trusty94710112trusty
tufty114810412tufty
tunny86515032tunny
tutty85217022tutty
undy85015172_undy
unity84918492_unity
unto45824282_unto
vaunty12409062vaunty

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.296603685.8
2DLD Change Limit538001091.64032804.9
3Display Results1091090.0303633.3
 (SQL Overall)1786911091.96690890.6
 
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.