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

132 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
orders7431599(None) 
borders104317531borders
corders104520881corders
order65019361order_
ormers84316141ormers
adders84315702adders
aiders74524632aiders
alders74218422alders
ardebs937012ardebs
ardors74416872ardors
armers85520272armers
biders94822802biders
birders103913262birders
boarders11408622boarders
bonders104120662bonders
bordels103911972bordels
border94419972border_
borers85122682bor_ers
briers85319732briers
carders104820352carders
ceders93817672ceders
ciders94620092ciders
codders114114452codders
coders95426982coders
corder94322882corder_
corers85231072cor_ers
corkers134118852corkers
corners94723312corners
criers83918582criers
cyders12398832cyders
dodders105511792dodders
dormers104313922dormers
dorpers104113172dorpers
dorsers83516302dorsers
driers74516732driers
dryers10449272dryers
eiders74321362eiders
elders74817302elders
enders74324052enders
faders105117462faders
fodders124010752fodders
folders113514392folders
forcers124215712forcers
forgers115218182forgers
forkers144615782forkers
formers128217952formers
freers94717302freers
friers94718932friers
fryers125710972fryers
girders9379942girders
gorgers94813642gorgers
graders94716012graders
heders104119762heders
herders113914122herders
hiders104919652hiders
hoarders12307432hoarders
holders113715902holders
hordes104921632horde_s
laders74927762laders
larders83516942larders
loaders83413432loaders
molders103315552molders
murders103311362murders
nodders94410262nodders
oaters65029792oaters
ochers113915302ochers
ockers123813902ockers
odder74515392odder_
odes57243242o_de_s
odors64514282o_dors
offers12349962offers
oglers74313182oglers
oilers64721192oilers
older65121172older_
ombers104214402ombers
omers76923192o_mers
ordeal779252ordeal
ordeals877992ordeals
ordered9108532ordered
orderer8127942orderer
orderers9116562orderers
orderly1135762orderly
ordos65216202ord_os
ordure756812ordure
ordures856472ordures
ores46056682or_e_s
oriels64914622oriels
orles55326212orle_s
ormer75218372ormer_
ornery938462ornery
orrery936782orrery
osiers63412792osiers
others93918002others
otters64021512otters
outers64230172outers
overs85224792o_vers
owners94210702owners
oxters134813272oxters
oyers87620882o_yers
polders103617372polders
ponders103618842ponders
porkers134314932porkers
porters93722702porters
powders134111552powders
priers84521192priers
pryers115012242pryers
reorders9198832reorders
riders74123902riders
rodeos75314502rodeos
rodes614039082rode_s
rogers74517912rogers
ropers84325902ropers
rovers95423522rovers
rowers94924572rowers
ruers515019412_ruers
seders74420282seders
solders83517772solders
sonders83820712sonders
sordors8310012sordors
sorners73416872sorners
sorters74221132sorters
traders84316952traders
triers64321522triers
udders83911292udders
urgers73313622urgers
voiders11279822voiders
waders109120642waders
warders113416812warders
wonders113315992wonders
workers144612692workers
wormers124012572wormers
yarders113211592yarders

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 Filter178691825510.500357382.0
2DLD Change Limit825511322.53032628.9
3Display Results1321320.0462869.6
 (SQL Overall)1786911323.07658092.0
 
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.