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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
intestacies135530(None) 
intestates10159432intesta_tes
testacies1148372__testacies
incessancies1652853incessancies
insectaries1354893insectaries
instancies1246613in__stancies
interfaces15410403interfac_es
interlaces12412043interlac_es
interspaces1546153interspac_es
interspecies1655093interspecies
interstates11710203intersta_tes
interstices1348523interstic_es
interties9320333intert__ies
intestacy1444133intestac__y
intestate9159873intesta_te_
intestines10410253intest_ines
intimacies1446413int_imacies
intricacies1554473intricacies
isostacies1244433i_sostacies
ancestries1246864ancest_ries
antistories1149374antistories
apostacies1445604_apostacies
entertains1047624enterta_ins
eustacies1146604__eustacies
immediacies1852574immediacies
inadequacies2461224inadequacies
inconstancies1763394inconstancies
indecencies1655824indecencies
indelicacies1752574indelicacies
industries1145284indust_ries
inerrancies1355044in_errancies
infestants1344504infesta_nts
infestation1447044infestation
infestations1546624infestations
inherencies1656474inherencies
injectables2252814injectables
injustices1953224injustic_es
insecticides1752604insecticides
insistencies1454054insistencies
instances1148744in__stances
instates81615834in__sta_tes
integrates111010784integra_tes
integrities1247784integrities
intendances1445554intendances
intensifies14105334intensifies
intensities11108914intensities
interacted13411214inte_racted
interacts11312124inte_rac_ts
interarches1645924interarches
interface14410164interfac_e_
interfaced1647934interfac_ed
interfacial1656294interfacial
interfacing1747704interfacing
interfacings1854354interfacings
interlace11311904interlac_e_
interlaced1349224interlac_ed
interlacing1449054interlacing
intermarries1454854intermarries
internalise111510554internalise
internalises12149114internalises
internalizes21138694internalizes
interrace11312544interrac_e_
interracial1357074interracial
interspace1446144interspac_e_
interspaced1644534interspac_ed
interspacing1755054interspacing
interstadial1354084interstadial
interstadials1462534interstadials
interstage1176404intersta_ge_
interstate10710974intersta_te_
interstation12410414interstation
interstice1249594interstic_e_
intertie8317614intert__ie_
intertwines1446644intertwines
intervales131010504interva_les
intestine9411854intest__ine
intraspecies1662804intraspecies
inventories1454704inventories
invertases1345784inverta_ses
investable1548044investable_
inveteracies1752764inveteracies
inviolacies1652794inviolacies
isostasies1043674i_sostasies
literacies1248804lite_racies
nectaries1149814_n_ectaries
retestifies1444534retestifies
tentacles1146714__tentacles
testates83615454__testa_tes
testicles1146774__testicles
testifies12139264__testifies
tetanies8513554__te_tanies
unteaches1446084unte__aches
untestable1248824untestable_

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.406440125.6
2DLD Change Limit148819938.43617640.9
3Display Results93930.0462021.7
 (SQL Overall)178691938.88820104.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.