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

171 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
jupe13492100(None) 
dupe76630601dupe
jape134923421jape
jube136322781jube
juke154721661juke
jupes145218551jupes
jute115327891jute
supe65932761supe
ape57251182_ape
bute66739672bute
cape87242782cape
cepe84926652cepe
cope86847382cope
coupe96023482coupe
cube85830212cube
cue57544182cu_e
cuke105824982cuke
cup76738242cup_
cupel9514302cupel
cups85430822cups
cure66149122cure
cute66440452cute
dope76038892dope
drupe85012992drupe
duce76933502duce
dude65629662dude
due45249862du_e
duke95628102duke
dune56137582dune
dup67637882dup_
duped95118322duped
duper85519002duper
dupes86425932dupes
duple85315862duple
dups75929512dups
dure56341812dure
fume96727632fume
fuse76429992fuse
fuze166422372fuze
gape75134512gape
gude65423332gude
hope96639672hope
hue66642302hu_e
huge86321652huge
hup86437812hup_
hype125519812hype
jade125325442jade
jake155925772jake
jane115031472jane
japed156217632japed
japer146218882japer
japes146322822japes
jaup135316422jaup_
jauped16457902jauped
jaups144810532jaups
jee106648642j_ee
jeep135624842jeep
jefe146516882jefe
jete115927252jete
jibe136323382jibe
jive146123592jive
joe106642352j_oe
joke155926162joke
jole117233822jole
joule124918202joule
juba134916982juba
jubes145420742jubes
juco134716202juco
judge144714152judge
judo125315302judo
jug115529542ju_g
juga126417322juga
jugs125525602jugs
juice14311322juice
juju103612122juju
juked175714072juked
jukes165319102jukes
juku154414852juku
julep14310532julep
jump156621722jump
jumped183511552jumped
jumper173612372jumper
jumps165116492jumps
jumpy195712812jumpy
jun105932062ju_n
junk155121032junk
jupon14479192jupon
jura116024892jura
jurel124516332jurel
jury146719592jury
jus106930222ju_s
just115433342just
jut105944012ju_t
jutes125125132jutes
juts115930162juts
kue76631862ku_e
kune85424572kune
lipe66839732lipe
lope65941922lope
loupe75319512loupe
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lune47140492lune
lure45142462lure
lute46341012lute
luxe115222692luxe
mope86838042mope
mule65236972mule
mure65941332mure
muse67136032muse
mute65136872mute
nape65230802nape
nope65934192nope
nude56626272nude
nuke85920752nuke
ope56845242_ope
ouph95618372ouph
ouphe104413262ouphe
pe47649032__pe
pipe86434432pipe
pope85535612pope
puce85127882puce
puke105025462puke
pule65040952pule
pup76339882pup_
pupa85422812pupa
pupae96515642pupae
pups86032232pups
pupu87620712pupu
pure65543332pure
rape65041632rape
ripe66038922ripe
rope65542912rope
rube65532012rube
rude55632782rude
rue35549262ru_e
rule49938422rule
rune45236292rune
rupee7321282rupee
ruse45938932ruse
sipe67341042sipe
spue66025522spue
stupe75217752stupe
sue35651462su_e
sup57041942sup_
super74924482super
supes75628302supes
sups64834432sups
sure45447412sure
tape64538142tape
taupe7314162taupe
tope65946382tope
tube65828662tube
tule45735872tule
tune45635862tune
tup56037542tup_
tups65628762tups
type96223742type
uke75727292_uke
up47832822_up_
upo58925862_upo
ups55629052_ups
use36835162_use
ute35335882_ute
wipe94830282wipe
yipe96722172yipe
yule75725142yule
yup86031702yup_
yups96121602yups

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 Filter178691298720.266671770.7
2DLD Change Limit298721712.18613665.1
3Display Results1711710.0762250.0
 (SQL Overall)1786911712.52870684.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.