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

104 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
aunty8591981(None) 
aunt46553651aunt_
auntly95211061auntly
aunts55227631aunts
jaunty16388511jaunty
punty106021611punty
runty86119041runty
vaunty12409061vaunty
acuity1139372acuity
amity10416092amity
annoy869712annoy
ant37270792a_nt_
anta46839582a_nta
ante46538902a_nte
anti45536362a_nti
ants47243472a_nts
antsy85712792a_ntsy
any68440492a_n_y
arty77531312a_rty
auntie64317702auntie
auto47432082au_to
awny105919302awn_y
banty106624002banty
bounty113411072bounty
bunny104715802bunny
bunt65850852bunt_
bunts75729802bunts
busty105621012busty
butty104020112butty
canty105226802canty
county114313322county
cunt66243672cunt_
cunts76125122cunts
cutty105417222cutty
dainty105311472dainty
daunt65929082daunt_
daunts75014082daunts
dungy104713642dungy
dunt55746872dunt_
dunts65828412dunts
dusty96018322dusty
duty85321452du_ty
faulty12429362faulty
flaunty1354412flaunty
funky154315132funky
funny114614832funny
fusty115016512fusty
gaunt65430402gaunt_
gauntly1135332gauntly
gauntry1154112gauntry
gunky135514112gunky
gunny94413662gunny
gusty95119572gusty
gutty94516992gutty
haunt85229132haunt_
haunts95614392haunts
hunky155417732hunky
hunt76445492hunt_
hunts86826172hunts
janty156816962janty
jaunt125025272jaunt_
jaunts137511882jaunts
junky194513232junky
junta123713672junta
junto125114562junto
jutty154914642jutty
linty87126562linty
lunt46148842lunt_
lunts55826902lunts
luny77324132lun_y
lusty85417572lusty
maundy12506782maundy
minty106323902minty
musty105620952musty
nutty84816872nutty
painty114714752painty
panty105929302panty
punky144419392punky
punny104217712punny
punt65747202punt_
punto75121322punto
punts75828002punts
puny95526992pun_y
purty105019402purty
putty104721402putty
runny84613482runny
runt46647982runt_
runts55927632runts
rusty85221052rusty
rutty85617802rutty
suety85318492suety
sunny84917742sunny
taunt55532282taunt_
taunts65715662taunts
tenty86121602tenty
tufty114810412tufty
tunny86515032tunny
tutty85217022tutty
undy85015162_undy
unity84918492_unity
unto45824282_unto
vaulty12388442vaulty
vaunt85925312vaunt_
vaunts95212622vaunts

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.0931921408.6
2DLD Change Limit538001041.67032215.6
3Display Results1041040.0333151.5
 (SQL Overall)1786911041.79699493.9
 
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.