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

257 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
ordering103935(None) 
bordering1338831bordering
cornering12311892cornering
doddering1335182doddering
foddering1535162foddering
moldering1367862moldering
murdering1357132murdering
nidering10510482nidering
ochering14219392ochering
offering1536392offering
overing111918052o_vering
pondering132411332pondering
portering122012302portering
powdering16246502powdering
reordering1266212reordering
rodeoing1037252rodeoing
rogering10310272rogering
soldering1169032soldering
wondering142110462wondering
adhering1338883adhering
adoring9412523_adoring
altering91917113altering
angering102113803angering
armoring1149123armoring
badgering1436963badgering
barbering14229683barbering
bartering122313643bartering
bedewing1537143bedewing
borderline1343733borderline
bothering152210203bothering
bouldering1464763bouldering
bowering142911713bowering
breeding123411843breeding
breezing20368133breezing
brewing133411153br_ewing
briefing1436943briefing
broidering1444673broidering
brokering1636283brokering
burdening1335543burdening
capering132414963capering
careering12311203careering
catering112019903catering
cering94522533__cering
cheering143612703cheering
chowdering2044163chowdering
cindering13311223cindering
cockering1839693cockering
coffering1838043coffering
cohering142413833cohering
compering163414163compering
coopering142611323coopering
coppering162810893coppering
corbeling1439033corbeling
cordelling1446383cordelling
cording113620823cord__ing
cordoning1338063cordoning
corseting12312173corseting
coshering15510023coshering
covering142215723covering
cowering142514033cowering
cratering12312653cratering
creeling113513363creeling
creeping133310103creeping
creping122913653cr_eping
crewing133212633cr_ewing
dandering122511063dandering
daring84928683__daring
deking125614553__deking
dewing114115703__dewing
disordering1444383disordering
dowering132510613dowering
dredging12236423dredging
dreeing94311183dr_eeing
during84419403__during
embordering1752623embordering
endearing1139323endearing
enduring10310013enduring
entering91920053entering
erring73816483er__ring
fedexing2034493fedexing
fevering152510083fevering
fleering123811283fleering
forbearing1644803forbearing
fording123717043ford__ing
fordoing1357303ford_oing
foredoing1456483foredoing
forewing1539003for_ewing
fostering132411263fostering
foundering1545353foundering
freeing113713913fr_eeing
freezing21308323freezing
gandering122111293gandering
gardening1236513gardening
garnering11298083garnering
gartering112111573gartering
gendering12249753gendering
goffering1744483goffering
gorgerin1044963gorgerin_
gorgerins1145193gorgerins
greeing93613783gr_eeing
greening103112533greening
greeting103112353greeting
greying124110893gr_eying
grieving1385893grieving
grueling1078273grueling
hardening1438023hardening
havering152211053havering
hindering14310273hindering
hoidening1435633hoidening
hollering1337743hollering
homering141512073homering
hoovering1635753hoovering
hordein1138753horde_in_
hordeins1238323horde_ins
hording123517053hord__ing
hovering151911143hovering
hoydening1744353hoydening
indexing1737123indexing
inhering12913713inhering
jeering153513043_jeering
juddering1933763juddering
koshering1735363koshering
laddering1237593laddering
ladening1078823ladening
lagering102212313lagering
layering122310353layering
leering83417643_leering
levering122212503levering
livering122012383livering
loitering1039683loitering
loppering14237283loppering
lording93115233lord__ing
lordling1077743lord_ling
loudening1144743loudening
lowering122210913lowering
metering112915633metering
misordering1544033misordering
mitering113015403mitering
modeling12311073modeling
modeming1437103modeming
mongering13310353mongering
morseling1238073morseling
mortaring1237943mortaring
mothering152110183mothering
mouldering1474283mouldering
niddering1255323niddering
niderings1175403niderings
oaring74225303o__aring
obeying1336543o_beying
observing1544393observing
obverting1536303obverting
ochring13156673o_chring
offerings1643653offerings
omening10310093o_mening
opening1039923o_pening
orating83520323or_ating
orbing93312363or__bing
orbiting1138153orbiting
orcein838183orce_in_
orceins937743orce_ins
ordain7810403ord_ain_
ordaining1145753ordaining
ordains879653ord_ains
order65019363order___
ordered9108533order_ed
orderer8127943order_er
orderers9116563orderers
orderlies1045453orderlies
orderly1135763order_ly
orders74315993order__s
orienting1038723orienting
ornerier846043ornerier
orreries8310123orreries
outdaring1179723outdaring
outring84021023o_utring
overdaring1539503overdaring
oystering1337563oystering
pandering133211963pandering
papering132213313papering
peering103520353_peering
perduring1336013perduring
petering112516813petering
pothering151911283pothering
pottering122612003pottering
powering142210803powering
predrying1645343predrying
preeing103817673pr_eeing
preening113115843preening
preordering15124303preordering
preying133114553pr_eying
queering1838203queering
raring74332873_r_aring
rearing83128783_rearing
redding103218513_redding
reding83825563_r_eding
redoing93516733_redoing
redrying13209023_redrying
redwing122811983_redwing
reeding94124133_reeding
reefing114016863_reefing
reeking123318643_reeking
reeling83126863_reeling
reeving113717663_reeving
rendering112213183rendering
rerig64018483_r_eri_g
revering122918073revering
roaring82916003_roaring
rodding103814533rod_ding
roweling122811123roweling
sabering112113743sabering
scowdering1743983scowdering
sering74731813__sering
severing122013853severing
sewering122411093sewering
sheering123715103sheering
sideling101012183sideling
smoldering1474103smoldering
sneering93414503sneering
sobering111912783sobering
soddening1244543soddening
soldiering1244243soldiering
speering113116323speering
sphering142811943sphering
spiering112713353spiering
steering93916793steering
sundering11312323sundering
supering11317683supering
tabering112211423tabering
tapering112112503tapering
teddering12256303teddering
tendering112210813tendering
tiering8315253_tiering
tochering1537153tochering
torturing1036253torturing
tottering10229613tottering
towering122610873towering
treeing83414303tr_eeing
trueing83410183true_ing
ulcering1139333ulcering
umbering1399433umbering
undaring10412753undaring
underling111514613underling
underwing141410883underwing
ushering1258923ushering
uttering91613083uttering
veering113213683_veering
wafering15208893wafering
wagering13219523wagering
wandering143310983wandering
watering122316313watering
wavering152410543wavering
wedeling1338773wedeling
widening13237833widening
wildering1456743wildering
wording123014563word__ing
worsening1345553worsening
yodeling1357673yodeling

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461622576.69021847.8
3Display Results2572570.1102336.4
 (SQL Overall)1786912577.20624797.5
 
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.