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

92 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
undies7382196(None) 
indies73822781indies
nudies75217091nudies
undines8716081undines
undoes73917401undoes
unties64326921unties
aunties73920072aunties
bandies104124862bandies
bodies94524142bodies
buddies113914352buddies
bundles103515772bundles
bunnies94415002bunnies
burdies104117562burdies
candies104125612candies
cuddies113313262cuddies
dandies94121442dandies
didies84621832didies
dies55653522__dies
eddies83313162eddies
endites83717062endites
endives113710692endives
endues73813902endues
envies9314052envies
fuddies123211202fuddies
funnies104113602funnies
gunnies83413122gunnies
hunkies143214502hunkies
hurdies114015662hurdies
indices103513442indices
indie63721472indie_
indites83618982indites
indues73515262indues
junkies183711692junkies
ladies75124882ladies
lindies8416582lindies
lunies64723012lun_ies
maundies1137852maundies
muddies113513952muddies
nides65229132_nides
nudes64723292nud_es
nudges84114742nudges
nudie65118672nudie_
oldies7314422oldies
pandies104224502pandies
pundits10379292pundits
punkies134216802punkies
punties94520782punties
randies84225662randies
rundles83214712rundles
sundaes8313092sundaes
sundries9312022sundries
tidies74721832tidies
todies74223552todies
tunnies73614262tunnies
uglies7412322uglies
unais53420772unai_s
uncles8317162uncles
unde55825482und_e_
undee65327272und_ee
under64624212und_er
undid72415362undi_d
undine7817262undine
undoer73113042undoer
undoers82910582undoers
undress838892undress
undrest8313012undrest
undrew1037912undrew
undried92314612undried
undue66715552undue_
undyed1138142undyed
unfits93910292unfits
unfixes17238112unfixes
ungues7412122ungues
unifies102714712unifies
unites65024852unites
unities72520152unities
units54923432un_its
unlives102010952unlives
unmixes16197752unmixes
unpiles92112782unpiles
unpins82312382unpins
unrigs7159002unrigs
unrips8199452unrips
untidies939812untidies
untie54425492untie_
untied73720812untied
unwise9510802unwise
unwits9389892unwits
unzips17175272unzips
updives1334712updives
updries10209082updries
wadies105121202wadies

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551922.51332849.6
3Display Results92920.0332787.9
 (SQL Overall)178691922.90661490.4
 
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.