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

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

115 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
intermarrying196228(None) 
interarching1845013inter_arching
interlarding1445563interla_rding
interlaying1547573interla__ying
intermarriage1662163intermarr_iage
intermarried1553633intermarr_ied
intermarries1454853intermarr_ies
intermarry1564153intermarry___
intermatting1547173interma_tting
interacting14411714inter_a_cting
intercalating1656504intercalating
interfacing1747704interfa__cing
interfering1558924inter_fer_ing
intergrading1545984inter_grading
intergrafting1854144intergrafting
interiorising14144914interiorising
interiorizing23144974interiorizing
interlacing1449054interla__cing
interlapping1754034interla_pping
interlayering1753054interlayering
intermarginal1672904interma_rginal
intermarriages1761594intermarr_iages
intermeddling1852564intermeddling
intermeshing1855054interm_eshing
intermingling1763044intermingling
intermitting1547254interm_itting
intermixing2146614interm__ixing
internalising1455624internalising
internalizing2356214internalizing
interplaying1845514inter_playing
interpreting1588304inter_preting
interring10315424inte___rr_ing
interspersing1654484interspersing
interworking2054524inter_working
remarrying1643374__re_marrying
watermarking2252684waterma_rking
countermarching2562605countermarching
enterprising1554085enter_prising
entertaining1354385enterta_ining
indemnifying2261545inde_mnifying
inearthing1443545in_e__arthing
inferring1338615infe___rr_ing
innerspring1452655inner_spr_ing
innervating1546365innerva__ting
instarring1144065in__starr_ing
integrating1349495inte__grating
intenerating1346725inte_nerating
intensifying1982565inte_nsifying
interabang1344485inter_a__bang
interbasin1246855interba__sin_
interbedding1754485inter_bedding
interbreeding1753195interbreeding
interceding1568045inter__ceding
intercepting1748875inter_cepting
interchanging2052995interchanging
intercomparing2162285intercompar_ing
intercropping2052805intercropping
intercrossing1653145intercrossing
intercurrent1454355intercurr_ent
intercutting1545945inter_cutting
interdicting1647455inter_dicting
interesting12411125inter__esting
interfacings1854355interfa__cings
interfiling1546955inter__filing
interflowing1953665inter_flowing
interfolding1754585inter_folding
interfusing1555835inter__fusing
intergang11117895interga____ng
interjecting2248395inter_jecting
interjoining2054655inter_joining
interknitting1853285interknitting
interknotting1852665interknotting
interleaving1676165inter_leaving
interlending1456415inter_lending
interlining1249135inter__lining
interlinking1755055inter_linking
interlocking1954905inter_locking
interlooping1554315inter_looping
interloping1446965inter__loping
intermediating1853985intermediating
intermedin1347445interm__edin_
intermedins1447385interm__edins
interning10315255inte____rning
interparish1655585interpa_r_ish
interparty1546855interparty___
interplanting1655345interplanting
interpleading1754205interpleading
interpolating1657795interpolating
interposing1447805inter__posing
interrelating1457295interrelating
interrobang1453655inter__robang
interrogating1556665interrogating
interrupting1546245inter_rupting
intersecting1549715inter_secting
interspacing1755055inter_spacing
interstrain1155865inter_strain_
intertilling1355375inter_tilling
intertwining1654225inter_twining
intertwisting1753315intertwisting
intervening1548175inter__vening
interviewing1964245inter_viewing
interweaving1985165inter_weaving
interworkings2152485inter_workings
inthralling1544115inthr_a_lling
intimating13410825int_ima__ting
intreating11614015int_rea__ting
introfying1744855int_r__ofying
introverting1654275int_roverting
inventorying1951285inve_ntorying
iterating10314255i_ter_a__ting
marrying14157235_____marrying
recarrying1643655__re_carrying
tarrying12146725__t___arrying
underlaying16125765underla__ying
underpaying18125375underpa__ying

Search took 10 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 Filter1786911247900.436409841.7
2DLD Change Limit1247901159.34613352.2
3Display Results1151150.0761513.2
 (SQL Overall)1786911159.85818126.5
 
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.