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

238 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
cubes9502816(None) 
cube85830211cube_
cubeb115814651cubeb
cubebs12508671cubebs
cubed105519701cubed
cuber95222531cuber
cubers105318341cubers
cubs85832381cub_s
cues65438981cu_es
cukes115422091cukes
cures75645431cures
cutes79438311cutes
jubes145420741jubes
lubes74727991lubes
pubes94423401pubes
rubes74928411rubes
tubes74826451tubes
abbes96723522abbes
acutes83917722acutes
aures55137092aures
babes95834112babes
bes56557432__bes
bubkes144612622bubkes
buboes104513992buboes
bubs86235492bub_s
bubus95115452bubus
buses75936012buses
butes714535872butes
caber95126832caber
cabers105023902cabers
cables104527552cables
cabs86739422cab_s
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cases75048382cases
cates75951872cates
caules85927252caules
causes88026472causes
caves105639702caves
cedes84927322cedes
cees65941592c_ees
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
chubs125412622chub_s
chutes114615762chutes
cines75239682cines
cires74932912cires
cites74435582cites
clubs95415102club_s
clues74623032clues
cobbs115013982cobbs
cobles104622882cobles
cobs87043142cob_s
codes86247292codes
cokes115537192cokes
coles76055062coles
combes125321732combes
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
cries75438402cries
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
cruxes154911562cruxes
cub76940942cub__
cubages1237922cubages
cubbies133312882cubbies
cubby145212112cubby
cubic114313412cubic
cubics123810152cubics
cubism12348692cubism
cubist104214432cubist
cubit94122882cubit
cubits103714022cubits
cuds76730472cu_ds
cue57544182cu_e_
cued76329562cu_ed
cuffs135017492cuffs
cuifs104814692cuifs
cuke105824982cuke_
culet76040342culet
culets85518512culets
culex144613932culex
culls75425812culls
culms95314192culms
cults75022552cults
cumber124016702cumber
cumbers134515392cumbers
cunts76125122cunts
cupel9514302cupel
cupels10310202cupels
cups85430822cu_ps
curbed114615872curbed
curber104517052curber
curbers115514372curbers
curbs94821652curbs
curds85725612curds
cure66149122cure_
cured85932132cured
curer75030752curer
curers84923182curers
curet75447642curet
curets84922342curets
curfs105122142curfs
curies84934022curies
curls74927102curls
curns74924272curns
currs75624392currs
curs65645542cu_rs
curse75829142curse
curses85328272curses
curves114619282curves
cusec94614902cusec
cusecs10509152cusecs
cusks114916052cusks
cusps94913672cusps
cuss65430612cu_ss
cusses84522772cusses
cute66440452cute_
cuter74728222cuter
cutest85820142cutest
cutesy114810732cutesy
cutey105819792cutey
cuteys11569972cuteys
cuties84927362cuties
cutis77723752cutis
cuts65841152cu_ts
cuvee10316142cuvee
cuvees1139372cuvees
cyber124910382cyber
cymes1210118922cymes
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
jibes145520322jibes
jubas144614222jubas
jube136322782jube_
jukes165319102jukes
jupes145218552jupes
jutes125125132jutes
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
pubis94616462pubis
pubs85029212pub_s
puces94924632puces
pukes114523022pukes
pules74538812pules
puses75532202puses
ribes75530172ribes
robes75133302robes
rube65532012rube_
rubel75416832rubel
rubels84112992rubels
rubies84420332rubies
rubles83921702rubles
rubs66133492rub_s
rubus76415052rubus
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sabes76437462sabes
scubas103710222scubas
scutes85219192scutes
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 5 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.186960704.3
2DLD Change Limit538002383.58015027.9
3Display Results2382380.1401700.0
 (SQL Overall)1786912383.90645747.8
 
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.