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

169 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
ruder6532054(None) 
cruder95612381cruder
nuder66416831nuder
rider65231301rider
rudder83812801rudder
rude55632781rude_
rudery10419031rudery
ruer46127561ru_er
ruler54923341ruler
adder75419592adder
aider65431132aider
alder65421912alder
arider74717742arider
auger64922472auger
aulder7511452aulder
bider85728372bider
budder104314812budder
budger104617702budger
buyer105013092buyer
ceder85322232ceder
cider84723312cider
coder86134212coder
crude86018572crude_
crudes96218622crudes
cuber95222532cuber
curer75030752curer
cuter74728222cuter
cyder114611132cyder
drudger10328322drudger
dude65629662dude_
duded84417132duded
dudes75424372dudes
duper85519002duper
eider64624742eider
elder64020022elder
eluder73712212eluder
ender64325862ender
fader94421512fader
fumer105918232fumer
funder104016082funder
grader84919692grader
grudger10368312grudger
gude65423332gude_
gudes74520812gudes
guider84313522guider
heder95623632heder
hider95024082hider
huger94914872huger
judder15439422judder
judger154411442judger
lader65633722lader
lauder73815012lauder
louder74414602louder
lude55331642lude_
ludes65728852ludes
luger65322082luger
lurer54625312lurer
mudder104413492mudder
murder93613782murder
muser76024122muser
muter74525542muter
nude56626272nude_
nudes64723292nudes
nudger85111632nudger
odder74515392odder
older65121172older
order65019362order
outer55633302outer
prouder10310372prouder
prude84615972prude_
prudery1335242prudery
prudes94215442prudes
pruner83413452pruner
puler74826622puler
purer75127902purer
queer143712812queer
racer75233022racer
radar61316722radar
raider74318742raider
raker94529792raker
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
reader73628292reader
redder83918132redder
rede55037662rede_
redear73515172redear
reded74829112reded
redes65139122redes
refer84822142refer
render74024142render
ricer74726612ricer
ridder84015142ridder
ride55945122ride_
riders74123902riders
rides66140812rides
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
rode55844302rode_
rodeo65921092rodeo
rodes614039082rodes
roger64521412roger
roper75431912roper
rounder83514592rounder
rouser65224082rouser
router65025842router
rover85527372rover
rower85430492rower
rubber104715792rubber
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rubier84814732rubier
rudd65917472rud_d
rudders93210642rudders
ruddier9338522ruddier
rudds74811702rudds
ruddy104511752ruddy
rudely10389972rudely
ruderal837372ruderal
rudest74016312rudest
rue35549262ru_e_
rued55729792ru_ed
ruers515019412ru_ers
rues46044482ru_es
rugger84414512rugger
ruiner64013642ruiner
rule49938422rule_
ruled65822522ruled
rulers64317092rulers
rules55234252rules
rulier65016352rulier
rumen74419502rumen
rummer104715482rummer
rumor71011322rumor
rune45236292rune_
runes55530222runes
runner63814462runner
rupee7321282rupee
ruse45938932ruse_
ruses56136582ruses
rusher94019652rusher
seder64826752seder
suber74924502suber
sudor6312622sudor
sudser73511282sudser
suer45334032su_er
sunder74019822sunder
super74924482super
surer54833092surer
trader75218752trader
trudger9338722trudger
truer54916642tru_er
tuber75420682tuber
tuner56022682tuner
tuyer85414292tuyer
udder76314282udder
under64624212under
urger64116472urger
user45023002_user
wader95325362wader
wider94826352wider

Search took 4 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 Limit538001693.31316239.1
3Display Results1691690.0931817.2
 (SQL Overall)1786911693.59249746.9
 
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.