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 “orderer” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

182 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
orderer812794(None) 
borderer1168101borderer
ordered9108531ordered
orderers9116561orderers
bordered1248932bordered
borderers1276332borderers
dodderer1144202dodderer
murderer1145262murderer
offerer1335542offerer
order65019362ord__er
orderly1135762orderly
orders74315992order_s
ordure756812ordure_
ordures856472ordures
ornerier846042ornerier
ponderer112410192ponderer
powderer14245592powderer
solderer947182solderer
sorcerer1036432sorcerer
verderer1245372verderer
wonderer12249182wonderer
adherer1137573adherer
adorer74713453_adorer
alterer72713993alterer
armorer9259913armorer
barterer102711633barterer
border94419973bord__er
bordereau1243323bordereau
borders104317533border_s
bordure1035783bordure_
bordures1136173bordures
boulderer1244403boulderer
breeder103210043breeder
brewer114812553br_ewer
briefer1235563briefer
broiderer1244353broiderer
burdener1136143burdener
caperer113013403caperer
careerer1038583careerer
caterer92815943caterer
cheerer123511753cheerer
coherer122912783coherer
corder94322883cord__er
corders104520883corder_s
cornered11311133cornered
coverer123113523coverer
creeper11339983creeper
crueler939023crueler
darer65230793__darer
dearer74822803__dearer
deer56739023__de_er
defer94619753__defer
dere56845903__dere_
deter65028043__deter
direr64927073__direr
doddered1234943doddered
dodderers1243803dodderers
dormered1255673dormered
dredger10347453dredger
eagerer8248823eagerer
endurer83210363endurer
enterer72015633enterer
foddered1434553foddered
forbearer1444513forbearer
forever1338953for_ever
fosterer11239523fosterer
freer86021243fr_e_er
freezer19348523freezer
frere85617723fr_ere_
freres94716173fr_eres
gardener1037103gardener
goldener1045403goldener
greener83111713greener
greeter82812673greeter
greyer104510093gr_eyer
griever1136033griever
grueler837023grueler
hardener1238883hardener
hinderer1238273hinderer
hoverer13319823hoverer
indexer15287253indexer
jeerer13389933_jeerer
loiterer837083loiterer
lordlier935363lordlier
merer75126233__merer
miterer92511333miterer
modeler1039293modeler
moderner1145523moderner
moldered1237173moldered
murdered1236023murdered
murderee1146843murderee
murderers1244593murderers
obeyer1135893o_beyer
observer1344733observer
ochered132610283ochered
odder74515393o_d_der
odored8399223o_dored
offered1436143offered
offerers1434933offerers
offeror1342943offeror
oftener1035923oftener
older65121173old__er
oldster896573oldster
onerier7311613o_nerier
opener83910993o_pener
orbier839993or_bier
orbiter937853orbiter
ordainer945223ordainer
ordeal779253orde_al
ordeals877993ordeals
ordering1039353ordering
orderless1044313orderless
orderlies1045453orderlies
ordines83014903ordines
orienter838313orienter
ormer75218373or__mer
ormers84316143ormer_s
ornery938463orner_y
orometer10310703orometer
orphrey15133393orphrey
orreries8310123orreries
orrery936783orrer_y
osiered837123osiered
overed102216623o_vered
oysterer1136103oysterer
panderer112210913panderer
paperer113111903paperer
pondered126411293pondered
ponderers12248453ponderers
portered112311543portered
potterer102310263potterer
powdered15256893powdered
powderers15214793powderers
preener93114833preener
prefer113813203pr_efer
preyer114413733pr_eyer
properer1259203properer
queerer16106503queerer
rarer54731703_r_arer
rearer64928913_rearer
redder83918143_redder
redrew10309513_redrew
reefer93314363_reefer
reeker103715593_reeker
reeler63822573_reeler
refer84822143_r_efer
renderer9239743renderer
reordered1145383reordered
reverer103815833reverer
riever94811653_riever
roarer63914333_roarer
rodeoed937883rodeoed
rogered939553rogered
serer55935513__serer
severer103511563severer
sheerer103813843sheerer
sneerer73512313sneerer
soberer93110353soberer
soldered1038153soldered
solderers1066533solderers
sorcerers1145323sorcerers
steerer73113633steerer
sunderer9310523sunderer
taperer92511793taperer
tenderer9228733tenderer
torturer835493torturer
totterer8217793totterer
unordered1145293unordered
ureter6313203ur_eter
utterer71910463utterer
verderers1344843verderers
verderor1243203verderor
wagerer11328493wagerer
wanderer122210123wanderer
waterer103314073waterer
waverer13319523waverer
widener11318693widener
wondered13239943wondered
wonderers13217933wonderers
woodener1245763woodener
wordier112511213word_ier
yodeler1136343yodeler

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271826.37621020.5
3Display Results1821820.0603033.3
 (SQL Overall)1786911826.82626178.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.