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 “galivanting” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
galivanting164252(None) 
galavanting1652341galavanting
gallivanting1751611gallivanting
gallanting1245342gal_lanting
salivating1447432saliva_ting
alienating1147223_alienating
alimenting1344503_alimenting
galantine1047323gal__antine
galivant1247083galivant___
galivanted1542553galivant_ed
galivants1344203galivant__s
galvanising16123343gal_vanising
galvanizing2594343gal_vanizing
glinting103210053g_li__nting
levanting1345523__levanting
validating1545833valida_ting
activating1647854activa_ting
advancing1643064_a_dvancing
agitating1138854_agita_ting
aliasing9310074_ali_a_sing
aliening91510894_ali_en_ing
alighting1446414_ali_ghting
aligning10158534_ali_gn_ing
alining81917044_ali__n_ing
animating12312504_anima_ting
aviating12311014_avi_a_ting
balancing1435784bal__ancing
ballasting1345294bal_lasting
calibrating1645344calibrating
captivating1944884captiva_ting
caravaning1644434caravan_ing
caravanning1752374caravanning
cavitating1646904cavita_ting
cultivating1744944cultiva_ting
elevating1338204_eleva_ting
enlivening1442934enliven_ing
estivating1447634estiva_ting
fainting123312164fa_i__nting
filiating1339244fili_a_ting
flinting123412344_fli__nting
foliating1339254foli_a_ting
gaining94015664ga_i__n_ing
gaiting93716584ga_i___ting
galantines1145734gal__antines
galavant1246354galavant___
galavanted1552524galavant_ed
galavants1343944galavant__s
galleting1137624gal__leting
gallivant1344494gallivant___
gallivanted1651774gallivant_ed
gallivants1442604gallivant__s
galvanic1444514gal_van_i_c
galvanise1344884gal_van_ise
galvanism1544524gal_van_ism
galvanize2245134gal_van_ize
gangbanging1551354gangbanging
garlanding1344434ga_rlanding
garmenting1445484ga_rmenting
gavotting1443194ga__votting
gelating103015734gel__a_ting
geminating1447764gemina_ting
glaciating1445594glacia_ting
glancing1247064g_l__ancing
gleaning10269324g_l_ean_ing
gloating102611464g_l_oa_ting
granting103514524g___ranting
gravitating1644004gravita_ting
italianating1352054itali_anating
laminating1348724lamina_ting
lapidating1445234lapida_ting
lariating10311784lari_a_ting
levantine1264794__levantine
ligating102212284__liga_ting
linting83820984__li__nting
livening12248154__liven_ing
maligning13145584mali_gn_ing
marinating13410264marina_ting
militating1348824milita_ting
motivating1646804motiva_ting
navigating1544994naviga_ting
obligating1445804obliga_ting
paginating1447524pagina_ting
painting113614424pa_i__nting
palisading1443894palisa_ding
palliating1347884pallia_ting
palpating1438534pal_pa_ting
palpitating1644654palpita_ting
passivating1743784passiva_ting
patinating1339874patina_ting
planting113515384_pl__anting
radiating111112124radi_a_ting
radicating1459064radica_ting
sainting93215734sa_i__nting
salivation1349814saliva_tion
salivations1448734saliva_tions
salvaging1465284sal_va_ging
sanitating1149644sanita_ting
satiating10311804sati_a_ting
slanting94115094_sl__anting
solvating1336444sol_va_ting
splinting1238194spli__nting
tailgating1244904tailga_ting
tainting93613584ta_i__nting
titivating1445324titiva_ting
valancing1544744val__ancing
valuating1338644val_ua_ting
variating13310944vari_a_ting
warranting1444744wa_rranting

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191088.18618179.7
3Display Results1081080.0631714.3
 (SQL Overall)1786911088.68520574.7
 
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.