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

165 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
order6501936(None) 
border94419971border
corder94322871corder
odder74515391odder
older65121171older
orders74315991orders
ormer75218371ormer
adder75419592adder
aider65431132aider
alder65421912alder
ardeb8314522ardeb
ardor64617862ardor
arider74717742arider
armer76924442armer
bider85728372bider
birder94915492birder
boarder103910322boarder
bolder94820932bolder
bonder95324782bonder
bordel94514572bordel
borders104317532borders
borer75131272bor_er
brier74527402brier
carder94524182carder
ceder85322232ceder
cider84723312cider
codder104416332codder
coder86134212coder
colder95121832colder
corded105923352corded
corders104520872corders
corer75538872cor_er
corker124720852corker
corner84625622corner
crier74724462crier
cruder95612382cruder
cyder114611132cyder
dodder94712912dodder
dormer94415892dormer
dorper94314562dorper
dorser74819172dorser
drier64423962drier
dryer95111462dryer
eider64624742eider
elder64020022elder
ender64325862ender
fader94421512fader
fodder114712112fodder
folder104317542folder
fonder104120062fonder
forcer114917342forcer
forded115020392forded
forger104820762forger
forker134717902forker
former114221402former
freer86021242freer
frier85225842frier
fryer115913432fryer
girder84312062girder
golder84417602golder
gorger86116982gorger
gorier73719372gorier
grader84919692grader
harder105022402harder
heder95623632heder
herder104516462herder
hider95024082hider
hoarder11329232hoarder
holder104619652holder
horde94623052horde_
horded115420482horded
hordes104921632hordes
lader65633722lader
larder73720972larder
loader74316302loader
lorded84916732lorded
louder74414602louder
molder93819272molder
murder93613782murder
nodder84811942nodder
nuder66416832nuder
oater55433732oater
ocher104516102ocher
ocker113915752ocker
ode47446582o_de_
odea56224572o_dea
odes57243242o_des
odor55718092o_dor
offer114311382offer
ofter84116872ofter
ogler65917442ogler
oiler54628282oiler
olden65114852olden
omber95316432omber
omer67028392o_mer
orbed85516192orbed
orbier839982orbier
ordeal779252ordeal
ordered9108532ordered
orderer8127942orderer
orderly1135762orderly
ordo54622352ord_o
ordos65216202ordos
ordure756802ordure
ore36661832or_e_
ores46056682or_es
oriel54920422oriel
orle45630462orle_
orles55326212orles
ormers84316142ormers
ornery938462ornery
orrery936782orrery
osier53518012osier
other84219102other
otter54423972otter
outer55633302outer
over77227342o_ver
owner84613312owner
oxter123414092oxter
oyer75927652o_yer
polder94019252polder
ponder94521692ponder
porker124917542porker
porter84224412porter
powder123611902powder
prier75027762prier
pryer104415312pryer
reorder8239482reorder
rider65231302rider
rode55844302rode_
rodeo65921092rodeo
rodes614039082rodes
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
ruder65320542ruder
ruer46127562_ruer
seder64826752seder
solder73921342solder
sonder73623522sonder
sordor7310212sordor
sorer56236572sor_er
sorner64720382sorner
sorter64425082sorter
trader75218752trader
trier54328532trier
truer54916642truer
udder76314282udder
under64624212under
urger64116472urger
voider103611552voider
wader95325362wader
warder104020272warder
wider94826352wider
wonder103617812wonder
worded114316622worded
wordier112511202wordier
worker134715112worker
wormer114514912wormer
worser95117522worser
wrier84521752wrier
wryer11489302wryer
yarder103813972yarder
yonder103214132yonder

Search took 2 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.0931921408.6
2DLD Change Limit538001651.76630464.3
3Display Results1651650.0463587.0
 (SQL Overall)1786911651.90593801.0
 
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.