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

168 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
jubes14542074(None) 
cubes95028161cubes
jibes145520321jibes
jubas144614221jubas
jube136322781jube_
jukes165319101jukes
jupes145218551jupes
jutes125125131jutes
lubes74727991lubes
pubes94423401pubes
rubes74928411rubes
tubes74826451tubes
abbes96723522abbes
aures55137092aures
babes95834112babes
bes56557432__bes
bubkes144612622bubkes
buboes104513992buboes
bubs86235502bub_s
bubus95115452bubus
buses75936012buses
butes714535872butes
cube85830212cube_
cubeb115814662cubeb
cubebs12508682cubebs
cubed105519702cubed
cuber95222532cuber
cubers105318342cubers
cubs85832382cub_s
cues65438982cu_es
cukes115422092cukes
cures75645432cures
cutes79438312cutes
daubes94913702daubes
dubs78432192dub_s
duces86327472duces
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunes65332172dunes
dupes86425932dupes
dures65635922dures
fubs96328792fub_s
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
gibes84422522gibes
gudes74520812gudes
gules64831042gules
gybes115012722gybes
hebes105521672hebes
hubs96027142hub_s
hues75235232hu_es
jabs135830092jab_s
jades135222112jades
jakes165023642jakes
jambes175914052jambes
janes124928122janes
japes146322822japes
jebel145612142jebel
jebels15418912jebels
jees115938542j_ees
jefes155613672jefes
jetes124922842jetes
jibbs16609742jibbs
jibe136323392jibe_
jibed155114162jibed
jiber145115702jiber
jibers155912882jibers
jibs136724082jib_s
jives154820812jives
jobs136529432job_s
joes116635892j_oes
jokes165423332jokes
joles125230832joles
jones125028182jones
joules134116822joules
juba134916982jub_a
jubiles16289372jubiles
jucos144111712jucos
judas134911882judas
judges153713452judges
judos134711732judos
jugs125525602ju_gs
juices1549422juices
jujubes1542082jujubes
jujus11347462jujus
juke154721662juke_
juked175714072juked
jukus16398672jukus
julep14310532julep
juleps1535622juleps
jumbles183013322jumbles
jumbos17379122jumbos
jumps165116492jumps
junks164815972junks
jupe134921002jupe_
jurel124516332jurel
jurels133710582jurels
juries134120632juries
jus106930222ju__s
justs124918262justs
jute115327892jute_
juts115930162ju_ts
kibes115521112kibes
kues86426772ku_es
lobes75331002lobes
lube64731562lube_
lubed85319892lubed
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
mabes96331532mabes
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
nabes75427092nabes
nubs65927142nub_s
nudes64723292nudes
nukes95418122nukes
obes66036832_obes
pubis94616472pubis
pubs85029212pub_s
puces94924632puces
pukes114523022pukes
pules74538812pules
puses75532202puses
ribes75530172ribes
robes75133302robes
rube65532012rube_
rubel75416832rubel
rubels84112992rubels
rubies84420342rubies
rubles83921702rubles
rubs66133492rub_s
rubus76415052rubus
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sabes76437462sabes
subas74724072subas
suber74924502suber
subers85722642subers
subs66037122sub_s
sues46247652su_es
supes75628302supes
tabes76033922tabes
tubas75119572tubas
tube65828662tube_
tubed85818042tubed
tuber75420682tuber
tubers85017022tubers
tubs65430062tub_s
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
ukes86122812_ukes
uses44931112_uses
utes45930882_utes
vibes104719952vibes
yules84521582yules

Search took 6 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.250714764.0
2DLD Change Limit538001684.12313048.8
3Display Results1681680.0931806.5
 (SQL Overall)1786911684.46640011.4
 
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.