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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
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
bumpy144715052bumpy
buoy95921782buoy
buppy144810072buppy
bury95633592bury
busy94727172busy
buy86436542bu_y
copy116229802copy
cup76738242cup_
cuppy144710382cuppy
cups85430822cups
dopy106224152dopy
duly85323032duly
dumpy135414752dumpy
dup67637882dup_
dupe76630602dupe
dups75929512dups
duty85321452duty
espy969372espy
fumy127118582fumy
fury107727972fury
gapy106320912gapy
gulpy114612762gulpy
guppy135211272guppy
guy75728942gu_y
humpy155115672humpy
hup86437812hup_
jumpy195712812jumpy
jupe134921002jupe
jury146719592jury
kapa106021292kapa
kaph135815752kaph
kaury12429762kaury
kay106745542k_ay
kelpy145110682kelpy
kep96437202kep_
kepi105315632kepi
keps106027302keps
kept106232942kept
key105833332k_ey
kip97042142kip_
kips106430522kips
kop97440202kop_
koph135816542koph
kops107031292kops
kudo96115112kudo
kudu95815432kudu
kue76631862ku_e
kues86426772kues
kufi11910652kufi
kumys1435932kumys
kuna85120702kuna
kune85424572kune
kuru85521802kuru
lumpy126615912lumpy
luny77324132luny
mopy115721972mopy
ouph95618372ouph
pipy115421512pipy
pulpy124612362pulpy
puny95526992puny
pup76339882pup_
pupa85422812pupa
puppy114912412puppy
pups86032232pups
pupu87620712pupu
quay164618352quay
quey164616472quey
ropy96323412ropy
roupy106112712roupy
ruby97819942ruby
ruly76323142ruly
soupy106115402soupy
spy86023742_spy
sup57041942sup_
supe65932762supe
sups64834432sups
tup56037542tup_
tups65628762tups
typy126013042typy
up47832822_up_
upby1139062_upby
upo58925862_upo
ups55629052_ups
yup86031702yup_
yuppy15487912yuppy
yups96121602yups

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 Filter178691298720.300595636.7
2DLD Change Limit29872861.10627009.0
3Display Results86860.0332606.1
 (SQL Overall)178691861.439124177.2
 
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.