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

114 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
vaultings1323364(None) 
vaulting12227231vaulting_
caulkings1633352caulkings
faulting12237732faulting_
saltings92811252sa_ltings
vaultingly1743412vaultingly
vaunting12338752vaunting_
ablings1038743_abl_ings
actings104512463_a_ctings
antings85015583_a_ntings
audings9289393_au_dings
avulsing1234433avulsing_
bantlings12216603bantlings
bastings114214693ba_stings
battings114010573ba_ttings
baulking1536003baulking_
beltings11369253_beltings
buntings11348773_buntings
calkings15289223ca_lkings
callings113613833ca_llings
carlings114015863carl_ings
castings113614053ca_stings
catlings113712043catl_ings
caulking1536803caulking_
cuttings11277613_cuttings
darlings103710383darl_ings
daunting103310403daunting_
dauting93814763dau_ting_
ductings12346673_ductings
dustings10419033_dustings
eanlings9128473eanl_ings
eastings93412953ea_stings
eatings84616443ea__tings
exulting1637643exulting_
fagotings1443153fagotings
failings123811013fail_ings
fastings124011943fa_stings
fatlings12359303fatl_ings
faultiness1344823faultiness
feltings12317903_feltings
flutings12357373flu_tings
foulings12327943foul_ings
gatings95212823ga__tings
halting114419073ha_lting_
hauling113714433haul_ing_
haunting123510053haunting_
huntings12328053_huntings
hustings12378683_hustings
jaunting16328633jaunting_
kartings13418523ka_rtings
kiltings13327083_kiltings
lastings94214423la_stings
laughings1443483laughings
lutings83311053_lu_tings
mailings113011923mail_ings
mallings113413093ma_llings
malting103219083ma_lting_
mantlings12207233mantlings
marlings113713503marl_ings
matings104516213ma__tings
mattings11369673ma_ttings
mauling103315683maul_ing_
mouldings13273953mouldings
moulting112710313moulting_
mountings12266163mountings
muntings11289813_muntings
nuttings9276783_nuttings
outings84014753_ou_tings
paintings12327103paintings
palings103915823pa_l_ings
partings113513743pa_rtings
paulins9312613paul_in_s
pulings103511323_pul_ings
quiltings19214683quiltings
railings93412163rail_ings
rallyings13313633rallyings
ratings84217413ra__tings
rattlings10235513rattlings
rulings83310383_rul_ings
sailings93513253sail_ings
saltines82917793sa_ltines
salting84120793sa_lting_
saluting9310553saluting_
saplings11269803sapl_ings
suitings9288953_suitings
tailings93211673tail_ings
talkings13358403ta_lkings
tattings9408823ta_ttings
taunting93510933taunting_
tauting83316383tau_ting_
tuftings12264323_tuftings
vacating14310363vacating_
vailing113817953vail_ing_
valeting1238853valeting_
valines104520213va_l_ines
valuating1338653valuating_
valuing11298843va_luing_
valving14368553va_lving_
vaporings1544093vaporings
vatting113614853va_tting_
vaulters11206173vault_ers
vaultier1144293vaulti_er
vaultiest1234833vaultiest
vaults94511673vault___s
vauntingly1743623vauntingly
veilings12357313veil_ings
vestings12359143v_estings
volutins1188003volutin_s
waistings1352710763waistings
waitings123413743wa_itings
walkings16327313wa_lkings
wauling112713113waul_ing_
weltings12388203_weltings
yachtings1842663yachtings

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411147.45319943.8
3Display Results1141140.0631809.5
 (SQL Overall)1786911147.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.