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

203 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
allowing1236909(None) 
alloying12339141alloying
fallowing1666431fallowing
hallowing1676941hallowing
sallowing1357381sallowing
tallowing1366291tallowing
wallowing1666071wallowing
allaying12339302allaying
alleging1038472alleging
allotting1046502allotting
alluding1036952alluding
alluring939072alluring
allying113011662all_ying
arrowing1237942arrowing
avowing1466602a_vowing
balloting1238382balloting
bellowing1547192bellowing
billowing1545872billowing
blowing133813052_blowing
elbowing1435012elbowing
fellowing1655922fellowing
flowing143411762_flowing
following1665752following
galloping1356252galloping
glowing123211792_glowing
halloaing1387032halloaing
halloing121510072hallo_ing
hallooing1366342hallooing
hollowing1675932hollowing
lowing104623272__lowing
mellowing1545892mellowing
pillowing1545492pillowing
plowing133111722_plowing
shallowing1744112shallowing
slowing112814742_slowing
swallowing1743042swallowing
walloping1545592walloping
willowing1645322willowing
yellowing1655072yellowing
ablating11311993ablating
aboding11410123a_boding
adoring9412523a_doring
ailing74331013ail__ing
alarming1138583alarming
alerting91312383alerting
aliasing9310073aliasing
alibiing1135323alibiing
aliening91510893aliening
aligning10158533aligning
alining81917043a_lining
allicin949953allicin_
allicins1049653allicins
allocating1347383allocating
allodia8128793allodi_a
allodial9117393allodial
allodium1145783allodium
allonge837023allo__nge
allow85420663allow___
allowance1444363allowance
allowancing1751593allowancing
allowed111610083allow_ed
allows94517683allow__s
alloxan1445773alloxan_
alloxans1545243alloxans
aloin55227423a_lo_in_
aloins65022203a_lo_ins
along65419493a_lo__ng
altering91917113altering
annoying1246543annoying
apposing1337403apposing
aproning11311793aproning
armoring1149123armoring
atoning83514873a_toning
autoing8314043auto_ing
awing96827323a___wing
balling104424763ball__ing
ballooning1344723ballooning
blawing134012753_blawing
blooding122410653blooding
blooming13299433blooming
blooping13248843blooping
bolloxing1944773bolloxing
bowing124723063__bowing
calling103826773call__ing
callousing1344273callousing
callusing1236173callusing
chowing164412773_chowing
clawing133812673_clawing
clewing13359583_clewing
cloning103215473_cloning
closing103114843_closing
clowning14307253_clowning
cloying133511753_cloying
coloring11414843coloring
cowing124526323__cowing
crowing133814763_crowing
dallying13368493dall_ying
disallowing1643283disallowing
dolloping1344993dolloping
dowing114221513__dowing
eloping103512833_eloping
embowing1636243embowing
endowing13178173endowing
falling113621583fall__ing
farrowing1645873farrowing
flawing143812563_flawing
flooding13238963flooding
flooring12259883flooring
flyblowing225913flyblowing
followings1752823followings
galleting1137623galleting
galling93921963gall__ing
gallying13328933gall_ying
galoping1258023galoping
globing113210003_globing
glooming12358013glooming
gloving12308443_gloving
glozing18338893_glozing
growing123512473_growing
gullwing13304923gullwing
haloing113814133halo_ing
harrowing1646433harrowing
helloing12159123hello_ing
hilloaing1375433hilloaing
hilloing12158303hillo_ing
holloaing1385793holloaing
holloing12148823hollo_ing
hollooing1385363hollooing
hulloaing1384523hulloaing
hulloing12146703hullo_ing
hullooing1383993hullooing
illuding1035803illuding
illuming1135873illuming
indowing13198083indowing
jowing174216043__jowing
knowing15287683_knowing
kotowing1634013kotowing
laboring112110143laboring
lacewing1435843lacewing
lalling83519623lal_ling
lapwing13308263_lapwing
lawing104625283__lawing
lolling83415773_lolling
lolloping1244683lolloping
looing73621043__looing
looking123415043_looking
looming102814853_looming
looping103615283_looping
loosing83515963_loosing
looting83019643_looting
loping93921413__loping
losing74022873__losing
loving104416723__loving
lowings113710073__lowings
loxing143615273__loxing
malling103623663mall__ing
marrowing1546663marrowing
meowing1368593_meowing
miaowing1434593miaowing
mowing124119093__mowing
narrowing1345603narrowing
owing96222723___owing
palleting1238733palleting
palling104024483pall__ing
piloting1139693piloting
ploying132811573_ploying
rallying12289013rall_ying
reflowing1636523reflowing
reglowing1436173reglowing
replowing1537413replowing
resowing123111523resowing
rowing103623303__rowing
sallowish1544943sallowish
sallying12309853sall_ying
salvoing1236423salvo_ing
scalloping1543953scalloping
scowing133812093_scowing
showing143814663_showing
siloing83215503silo_ing
slaloming1244743slaloming
slewing113311353_slewing
sloping104114073_sloping
snowing113913453_snowing
soloing82813803solo_ing
sowing104222913__sowing
stowing113315133_stowing
strowing122310563strowing
tailoring1036403tailoring
tallaging1146483tallaging
tallying12318833tall_ying
throwing1536723throwing
towing103823193__towing
trowing113413703_trowing
unbowing1436993unbowing
unhallowing1851423unhallowing
unloving1277483unloving
upflowing1842933upflowing
vowing133715273__vowing
walling113520973wall__ing
wallopings1652713wallopings
widowing1635183widowing
wowing133915393__wowing
yowing133715543__yowing

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.423422437.4
2DLD Change Limit1461622037.23320207.7
3Display Results2032030.0762671.1
 (SQL Overall)1786912037.73223110.6
 
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.