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

365 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
awaiting123827(None) 
waiting113618951_waiting
abating10413972aba_ting
adapting1236642adapting
auditing1039032auditing
availing1267282availing
aviating12311012aviating
awaking1547812awa_king
awarding1356042awarding
baiting103918882_baiting
gaiting93716582_gaiting
plaiting113113512plaiting
swatting12309592swatting
wafting143911662_wafting
waifing142910892_waifing
wailing113620902_wailing
wairing113414312_wairing
waisting123615212_waisting
waitings123413742_waitings
waiving14329632_waiving
wanting114220172_wanting
wasting114422842_wasting
whiting143311302_whiting
witing103522822_w_iting
writing113713892_writing
aahing1019015763a_a_hing
abashing1466623abashing
abasing10610673aba_sing
abetting1158293abetting
abiding11510503a_biding
ablating11311993ablating
aborting11710253aborting
abutting1137003abutting
acting95920983__acting
addicting1485073addicting
admiring1236133admiring
admitting1345033admitting
admixing1944133admixing
adopting1237453adopting
advising1336153advising
aerating92821003aerating
affixing2264333affixing
agatizing2087473agatizing
agenting1039383agenting
agisting1038243agisting
agnizing1936833agnizing
aiding84423613__aiding
ailing74331013__ailing
aiming94320843__aiming
airing74927503__airing
airting83616303a_irting
alarming1138583alarming
alerting91312383alerting
aliasing9310073aliasing
alining81917043a_lining
amanitin1048463amanitin_
amanitins1147133amanitins
amassing1138003amassing
amazing1938813ama_zing
anointing1038623anointing
antiking13412073antiking
anting75827023__anting
anviling1239743anviling
arabizing2147963arabizing
arising83619973a_rising
arointing1049363arointing
arriving1237363arriving
aspiring1138873aspiring
assailing1036023assailing
assisting1046183assisting
attaining1047223attaining
attainting1144783attainting
attiring939483attiring
attriting1048683attriting
averting122512733averting
avoiding1336783avoiding
await85524493await___
awaited1146963await_ed
awaiter1057443await_er
awaiters1146643awaiters
awaits96411953await__s
awakening1743203awakening
aweing103911253aw__eing
awing96827323aw___ing
awning105013393aw__ning
bailing103723523_bailing
basting104227203_basting
bating95132253_ba_ting
batting104422273_batting
beating104326873bea_ting
bewailing1536063bewailing
biting95321823__biting
blasting114013423blasting
blatting114111653blatting
boasting113512493boasting
boating103721303boa_ting
braiding123112703braiding
brailing113514793brailing
braining113414683braining
braising113014563braising
bruiting11259973bruiting
canting104725903_canting
carting104228283_carting
casting104628343_casting
catting103922643_catting
chaining142810783chaining
chairing143110773chairing
chanting143413533chanting
charting142614193charting
chatting142810143chatting
citing94220183__citing
claiming13279303claiming
coacting133412703coacting
coapting133511613coapting
coasting113615513coasting
coating103525313coa_ting
cowriting1557323cowriting
crafting143710173crafting
crating103725203cra_ting
darting94020663_darting
dating85326483_da_ting
dauting93814763_dauting
dawting123610673_dawting
deairing10311893deairing
debiting122511203debiting
doating93816863doa_ting
drafting13339403drafting
draining103312673draining
dratting10389653dratting
dwarfing1633613dwarfing
dwining12269293dw_ining
easting84924303_easting
eating75134403_ea_ting
editing9313133_editing
elating83423083ela_ting
emailing113010043emailing
enacting11311363enacting
enditing10311073enditing
eviting11511373_eviting
exacting1838523exacting
exalting1638033exalting
exciting1838023exciting
exiting15311393_exiting
failing113521333_failing
fainting123312163_fainting
fairing113614013_fairing
faithing1537153_faithing
farting114120753_farting
fasting114522833_fasting
fating105328673_fa_ting
fatting113818703_fatting
feasting122011323feasting
flailing12298923flailing
flatting123511253flatting
fliting113514613_fliting
fruiting12229063fruiting
gaining94015663_gaining
gasting95022763_gasting
gating84826953_ga_ting
glairing1047283glairing
grafting13319623grafting
graining102813183graining
granting103514523granting
grating93923183gra_ting
habiting1437533habiting
hafting144014173_hafting
hailing113820693_hailing
halting114419073_halting
hanting114124483_hanting
hasting114725193_hasting
hating104929713_ha_ting
hatting113920233_hatting
hearting12513123hearting
heating114024323hea_ting
igniting1037363igniting
inciting11312533inciting
inditing10312113inditing
inviting1239733inviting
jailing153415843_jailing
karting123716063_karting
kiting114117093__kiting
lairing83715343_lairing
lariating10311783lariating
lasting84725243_lasting
lawgiving1762143lawgiving
leniting9312353leniting
liaising937913liaising
limiting1138813limiting
mailing102923343_mailing
maiming122912723_maiming
malting103219083_malting
marting103325013_marting
masting104325823_masting
mating94832913_ma_ting
matting103620143_matting
meriting11314683meriting
moating104218153moa_ting
nailing83419963_nailing
opiating11410093opiating
orating83520323ora_ting
orbiting1138153orbiting
outwaiting1446733outwaiting
paiking143814813_paiking
paining103920243_paining
painting113614423_painting
pairing103716733_pairing
panting104025423_panting
parting103527383_parting
pasting103826553_pasting
patting103722343_patting
plaining113911553plaining
plaitings12296243plaitings
planting113515383planting
plating103823073pla_ting
platting114813033platting
positing11312303positing
praising113214563praising
prating103424453pra_ting
quailing1838403quailing
quanting1849233quanting
quoiting1836093quoiting
rabbiting1445033rabbiting
radiating111112123radiating
rafting113815753_rafting
raiding93617593_raiding
railing83325643_railing
raining83922693_raining
raising83220533_raising
ranting84025413_ranting
rating74938703_ra_ting
ratting83822363_ratting
rawhiding1743113rawhiding
reacting113317893reacting
rebaiting12311643rebaiting
reciting113118073reciting
resiting93521123resiting
rewriting13310413rewriting
roasting93012693roasting
sailing83927373_sailing
saining83621393_saining
sainting93215733_sainting
salting84120793_salting
satiating10311803satiating
sating74735453_sa_ting
scanting113914763scanting
scarting113415263scarting
scatting113311813scatting
seating84130683sea_ting
shafting15278683shafting
siting74126623__siting
skating123613853ska_ting
skiting123812503_skiting
slanting94115093slanting
slating83724653sla_ting
slatting94014233slatting
smarting113212453smarting
smiting103014443_smiting
snailing92912973snailing
sopiting11310763sopiting
spatting113111763spatting
spiting103917623_spiting
staining9413373staining
starting93116173starting
stating83725163sta_ting
suiting83419003_suiting
swabbing16246453swabbing
swagging14328093swagging
swaging124210633swa_ging
swamping16307923swamping
swanking16399963swanking
swanning12338813swanning
swapping16348673swapping
swarding1359003swarding
swarming1458223swarming
swashing15369743swashing
swathing15248713swathing
swaying143610643swa_ying
sweating123213023sweating
sweeting123911313sweeting
swiping13319823sw_iping
swiving14358953sw_iving
swotting12268483swotting
tailing82923103_tailing
tainting93613583_tainting
tarting84222653_tarting
tasting84624213_tasting
tatting84019523_tatting
tauting83316383_tauting
thwarting1632763thwarting
toasting93410573toasting
toiting83217093_toiting
traiking132511973traiking
trailing92916093trailing
training93015863training
twanging13287063twanging
twattling1332693twattling
tweeting12267033tweeting
twining113211443tw_ining
twisting12427813twisting
twitting12307223twitting
uniting8315823_uniting
upwafting1842063upwafting
vacating14310353vaca_ting
vailing113817943_vailing
variating13310943variating
vatting113614853_vatting
visiting1238393visiting
vomiting1437733vomiting
wadding133711943_wadding
wading114619533_wa_ding
waffing173710243_waffing
wagging133313353_wagging
waging114318383_wa_ging
waistings1352710763_waistings
waitering13310713_waitering
waking144821383_wa_king
waling104525303_wa_ling
walking154013303_walking
walling113520973_walling
waltzing2134263_waltzing
waning103623803_wa_ning
wanking154216783_wanking
wanning113816213_wanning
wapping153514603_wapping
warding123918143_warding
waring105029443_wa_ring
warking153519573_warking
warming133515083_warming
warning113717093_warning
warping133715183_warping
warring113717973_warring
washing145119283_washing
wattling12258783_wattling
wauking153410013_wauking
wauling112713113_wauling
waving134018203_wa_ving
wawling143810963_wawling
waxing174215283_wa_xing
waxwing2154723_waxwing
weeting113816053_weeting
welting113615313_welting
westing115020273_westing
wetting114117383_wetting
whiling143511743_whiling
whining143311673_whining
whisting15329543_whisting
whitings15287063_whitings
wifing133513393_w_ifing
wiling103024293_w_iling
wilting113515913_wilting
wining103625053_w_ining
wiping123916713_w_iping
wiring104521023_w_iring
wising103318223_w_ising
wisting113519743_wisting
withing143814493_w_ithing
witling113215813_w_itling
witting113417063_witting
wiving133316603_w_iving
wonting113214103_wonting
wotting112913843_wotting
writhing15278673_writhing
writings12298113_writings
wyting13277243_w_yting
yeasting12188923yeasting

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.1701051123.5
2DLD Change Limit1461623657.37619815.9
3Display Results3653650.1562339.7
 (SQL Overall)1786913657.70223200.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.