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

275 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
waltzing213426(None) 
halting114419072halt_ing
malting103219082malt_ing
salting84120792salt_ing
wafting143911662waft_ing
waiting113618952wait_ing
waling104525302wal__ing
walking154013302wal_king
walling113520972wal_ling
wanting114220172want_ing
wasting114422842wast_ing
wattling12258782wattling
welting113615312welt_ing
wilting113515912wilt_ing
acting95920983_act_ing
adzing174110013_a_dzing
alining81917043_alining
allying113011663_allying
altering91917113_altering
amazing1938813_amazing
analyzing2245153analyzing
anteing8312813_anteing
anting75827023_ant_ing
autoing8314043_autoing
awaiting1238273await_ing
baiting103918883bait_ing
balding114015063bal_ding
baling94829693bal__ing
balking143717353bal_king
balling104424763bal_ling
bantling112612003bantling
baptizing2345843baptizing
basting104227203bast_ing
bathing134816243ba_thing
bating95132253ba_t_ing
batting104422273ba_tting
battling113110493battling
batwing13509813ba_twing
belting104119133belt_ing
blatting114111653blatting
blazing193612393_blazing
blitzing2035903blitzing
bolting104416763bolt_ing
calking144617783cal_king
calling103826773cal_ling
calming123915973cal_ming
calquing2035593calquing
calving134113503cal_ving
canting104725903cant_ing
carting104228283cart_ing
casting104628343cast_ing
castling11311233castling
catling104819793ca_tling
catting103922643ca_tting
dallying13368493dallying
darting94020663dart_ing
dartling1039563dartling
dating85326483da_t_ing
dauting93814763daut_ing
dawting123610673dawt_ing
dazing175516513da__zing
dialyzing2344043dialyzing
dualizing2047783dualizing
earthing12310323earthing
easting84924303east_ing
eating75134403ea_t_ing
elating83423083elat_ing
exalting1638033exalt_ing
faithing1537153faithing
falling113621583fal_ling
faltering132211113faltering
farthing1538073farthing
farting114120753fart_ing
fasting114522833fast_ing
fating105328673fa_t_ing
fatling113815683fa_tling
fatting113818703fa_tting
faulting12237733fault_ing
fazing194418643fa__zing
felting113515213felt_ing
flatling123410013flatling
flatting123511253flatting
futzing20307903_futzing
gaiting93716583gait_ing
galling93921963gal_ling
gallying13328933gallying
galoping1258023galoping
gasting95022763gast_ing
gating84826953ga_t_ing
gazing174717173ga__zing
glazing183611003_glazing
glitzing1934973glitzing
glozing18338893_glozing
hafting144014173haft_ing
haling104229783hal__ing
halloing121510073halloing
haloing113814133hal_oing
haltering132212003haltering
halving143511543hal_ving
hanting114124483hant_ing
hasting114725193hast_ing
hating104929713ha_t_ing
hatting113920233ha_tting
hazing194218553ha__zing
hilting113316893hilt_ing
jazzing2333883ja_zzing
jilting153211743jilt_ing
jolting153410913jolt_ing
karting123716063kart_ing
kilting123213853kilt_ing
lalling83519623lal_ling
lasting84725243last_ing
lathing114315693la_thing
lazing164821473__lazing
lilting83515383lilt_ing
malling103623663mal_ling
mantling112012613mantling
marting103325013mart_ing
masting104325823mast_ing
mating94832913ma_t_ing
matting103620143ma_tting
mazing184418973ma__zing
melting103317753melt_ing
milting103619123milt_ing
molting103517173molt_ing
naething1236073naething
paling93530133pal__ing
palling104024483pal_ling
palming123914013pal_ming
palping124112873pal_ping
palsying1436233palsying
paltering122612893paltering
panting104025423pant_ing
parting103527383part_ing
partying14168893partying
pasting103826553past_ing
patting103722343pa_tting
pelting102917273pelt_ing
plating103823073plat_ing
platting114813033platting
plotzing20276153plotzing
putzing19359123_putzing
rafting113815753raft_ing
rallying12289013rallying
ralphing1435413ralphing
ranting84025413rant_ing
rating74938703ra_t_ing
ratting83822363ra_tting
rattling92510873rattling
razing164524543ra__zing
razzing1636323ra_zzing
realizing19313813realizing
sallying12309853sallying
saltine75018563salt_ine
saltings92811253salt_ings
saluting9310553saluting
salving113913153sal_ving
salvoing1236423salvoing
sating74735453sa_t_ing
sauteing937913sauteing
silting83320483silt_ing
slating83724653slat_ing
slatting94014233slatting
swathing15248713swa_thing
swatting12309593swa_tting
talcing103111633tal_cing
talcking1567083talcking
talking123815823tal_king
tallying12318833tallying
tarting84222653tart_ing
tasting84624213tast_ing
tatting84019523ta_tting
tattling9259473tattling
tauting83316383taut_ing
tilting83417103tilt_ing
twattling1332693twattling
valeting1238843valeting
valuing11298843val_uing
valving14368553val_ving
vatting113614853va_tting
vaulting12227223vault_ing
wabbling16207743wabbling
wadding133711943wa_dding
waddling14237933waddling
waddying17204723waddying
wading114619533wa__ding
wafering15208893wafering
waffing173710243wa_ffing
waffling1845423waffling
wagering13219523wagering
wagging133313353wa_gging
waggling14197063waggling
waging114318383wa__ging
wagoning1336923wagoning
waifing142910893wa_ifing
wailing113620903wa_iling
wairing113414313wa_iring
waisting123615213waisting
waitering13310713waitering
waitings123413743wait_ings
waiving14329633wa_iving
wakening1636323wakening
waking144821383wa__king
walkings16327313wal_kings
walloping1545593walloping
wallowing1666073wallowing
waltz17615473waltz___
waltzed2033493waltz_ed
waltzer1934383waltz_er
waltzers2034003waltzers
waltzes1935953waltz_es
wambling16198443wambling
wangling132310993wangling
waning103623803wa__ning
wanking154216783wa_nking
wanning113816213wa_nning
wantoning1337083wantoning
wapping153514603wa_pping
warbling14198943warbling
warding123918143wa_rding
waring105029443wa__ring
warking153519573wa_rking
warming133515083wa_rming
warning113717093wa_rning
warping133715183wa_rping
warring113717973wa_rring
warsling12198593warsling
warstling1335063warstling
washing145119283wa_shing
watching173011173watching
watering122316313watering
wauking153410013wa_uking
wauling112713113wa_uling
wavering152410543wavering
waving134018203wa__ving
wawling143810963wa_wling
waxing174215283wa__xing
waxwing2154723wa_xwing
waygoing1633273waygoing
waylaying1953103waylaying
weeting113816053weet_ing
welching17287363welching
welding123213253wel_ding
welling112920313wel_ling
welshing15296523welshing
weltering13219493weltering
weltings12388203welt_ings
westing115020273west_ing
wetting114117383w_etting
whaling143910773whal__ing
wheezing24315383wheezing
whetting1535973whetting
whiting143311303whit_ing
whizzing2333383whizzing
wilding123814293wil_ding
wildling13248083wildling
wiling103024293wil__ing
willing113821613wil_ling
willying15306713willying
wintling12249923wintling
wisting113519743wist_ing
withing143814493w_ithing
witing103522823w_it_ing
witling113215813w_itling
witting113417063w_itting
wolfing14277893wol_fing
wonting113214103wont_ing
worthing15178053worthing
wotting112913843w_otting
wrastling1335523wrastling
wrathing15248923wrathing
writhing15278673writhing
writing113713893writ_ing
wyling13368553wyl__ing
wyting13277243w_yt_ing

Search took 9 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.1731032896.0
2DLD Change Limit1461622757.79618748.3
3Display Results2752750.1102500.0
 (SQL Overall)1786912758.07922118.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.