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

146 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
cuber9522253(None) 
caber95126831caber
cube85830211cube_
cubeb115814661cubeb
cubed105519701cubed
cubers105318351cubers
cubes95028161cubes
cumber124016701cumber
curber104517051curber
curer75030751curer
cuter74728231cuter
cyber124910381cyber
suber74924501suber
tuber75420681tuber
acuter84412862acuter
amber94523212amber
auger64922472auger
buyer105013092buyer
cabers105023922cabers
cabler104519172cabler
cager85229222cager
camber124418482camber
caner75334772caner
caper94831622caper
carer74942332carer
cater74840722cater
causer84117782causer
caver105629062caver
ceder85322242ceder
cheer105420382cheer
cider84723312cider
citer74827332citer
clubber13319592clubber
clumber134011442clumber
cobber124116842cobber
coder86134222coder
comber125118502comber
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
couter84930222couter
cover105430772cover
cower104531772cower
coyer105222842coyer
crier74724462crier
cruder95612382cruder
crumber13339642crumber
cub76940942cub__
cubby145212122cubby
cubebs12508682cubebs
cubic114313422cubic
cubit94122892cubit
cubs85832382cub_s
cudbear1233332cudbear
cue57544182cu_e_
cued76329562cu_ed
cues65438982cu_es
cuke105824982cuke_
cukes115422092cukes
culet76040342culet
culex144613932culex
culler84322252culler
culver113010632culver
cumbers134515412cumbers
cummer124414592cummer
cunner83915002cunner
cupel9514302cupel
cupper124313862cupper
cur56841982cu__r
curbed114615872curbed
curbers115514382curbers
cure66149122cure_
cured85932132cured
curers84923192curers
cures75645432cures
curet75447642curet
curler85221322curler
curr65429652cu_rr
curser84721472curser
curter85320082curter
cusec94614902cusec
cusser86016092cusser
cute66440452cute_
cutes79438322cutes
cutey105819792cutey
cutler84718032cutler
cutter84521002cutter
cuvee10316142cuvee
cyder114611132cyder
dauber94112012dauber
dubber113814552dubber
dumber114414172dumber
duper85519002duper
ember95516802ember
fiber104921132fiber
fubar1039922fubar
fumer105918232fumer
giber85417702giber
huger94914872huger
jiber145115702jiber
jube136322782jube_
jubes145420742jubes
liber74723622liber
lubber104214622lubber
lube64731562lube_
lubed85319892lubed
lubes74727992lubes
luger65322082luger
lumber103817772lumber
lurer54625312lurer
muser76024122muser
muter74525542muter
nuder66416832nuder
number103913222number
omber95316442omber
outer55633302outer
pubes94423402pubes
puler74826622puler
purer75127902purer
queer143712812queer
rubber104715792rubber
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rubier84814742rubier
ruder65320542ruder
ruer46127562ru_er
ruler54923342ruler
saber75330242saber
sober74822412sober
subers85722642subers
suer45334032su_er
super74924482super
surer54833102surer
taber73825822taber
tubber104313202tubber
tube65828662tube_
tubed85818042tubed
tubers85017032tubers
tubes74826452tubes
tuner56022682tuner
tuyer85414292tuyer
umber94617592umber
user45023002_user
weber10313522weber

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 Filter178691538000.310576422.6
2DLD Change Limit538001461.70331591.3
3Display Results1461460.0463173.9
 (SQL Overall)1786911462.05986785.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.