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

116 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
jaups14481053(None) 
jauks165412461jauks
jaup135316421jaup_
yaups105910741yaups
alps65529242_alps
amps86230342_amps
apps86319692_apps
asps65622092_asps
auks85525262_auks
baps86040842ba_ps
bauds85821042bauds
camps116330262camps
caps87147892ca_ps
carps96932252carps
cauls75727772cauls
coups95522472coups
cups85430822_cups
damps105220412damps
daps77239162da_ps
daubs85014562daubs
dauts67822242dauts
dups75929512_dups
fauns84516752fauns
gamps105323712gamps
gaps76042972ga_ps
gasps85415482gasps
gauds75717722gauds
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
gawps115911012gawps
haps96443462ha_ps
harps105926872harps
hasps105114642hasps
hauls86123732hauls
jabs135830092ja_bs
jacks185219832jacks
jades135222112jades
jaggs148111492jaggs
jags126132792ja_gs
jails125422942jails
jakes165023642jakes
jalaps15299182jalaps
jalops15329592jalops
jambs166014622jambs
jams135231072ja_ms
janes124928122janes
jape134923422ja_pe
japes146322822japes
jarls126120962jarls
jars117338352ja_rs
jatos125116822jatos
jauk155816092jau_k
jaunt125025272jaunt
jaunts137511882jaunts
jauped16457902jauped
javas155915422javas
jaws145027292ja_ws
jays146328342ja_ys
jeeps144715372jeeps
jouks165612342jouks
jugs125525602j_ugs
jumps165116492jumps
jupe134921002j_upe
jupes145218552j_upes
jus106930222j_u_s
juts115930162j_uts
lamps95624832lamps
laps66848872la_ps
lauds65618482lauds
layups1133992layups
loups75319622loups
maps86141052ma_ps
mauds85519272mauds
mauls76524952mauls
mauts75927192mauts
naps66238582na_ps
palps94719562palps
paps86443452pa_ps
pups86032232_pups
ramps96224632ramps
raps66247732ra_ps
rasps74316662rasps
roups75118902roups
salps74423242salps
samps96124672samps
saps65346372sa_ps
sauls55128122sauls
scaups105411932scaups
scups95316652scups
soups75322942soups
sups64834432_sups
tamps95524082tamps
taps66050672ta_ps
tarps76527112tarps
taupe7314162taupe
taupes8212672taupes
taus46342732tau_s
tauts56125512tauts
tups65628762_tups
ups55629052__ups
vamps125415482vamps
vaus75928922vau_s
waps96642082wa_ps
warps107126422warps
wasps106714692wasps
wauks125515162wauks
wauls86120552wauls
whaups14405752whaups
whups134210002whups
yaps95933522ya_ps
yauds95013222yauds
yaup96618482yaup_
yawps13628792yawps
yups96121602_yups
zaps156826892za_ps

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.0762351197.4
2DLD Change Limit538001161.70331591.3
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.81298615.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.