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

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

153 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
investigational1961931investigational_
investigation1754083investigation___
investigations1853723investigation__s
investigating1853344investigati_n__g
inspirational1554415in__spirational_
instigation1249245in__stigation___
instigations1348245in__stigation__s
institutional1353505in__stitutional_
interrogational1693905interrogational_
investigative2062635investigati___ve
investigator1652765investigat_o___r
investigators1752465investigat_o__rs
investigatory2062235investigat_o__ry
invitational1554905inv___itational_
invitationals1652745inv___itationals
reinvestigation1962185reinvestigation___
antinational1297486an___tinational_
antirational1278496an___tirational_
gestational1245116__gest__ational_
illustrational1461556illust_rational_
incantational1553566incant__ational_
inclinational1553936in__clinational_
indicational1545756in___dicational_
infestation1447046infest__ation___
infestations1546626infest__ation__s
inspirationally2072546in__spirationally
instigating1347156in__stigati_n__g
institutionally1872136in__stitutionally
instructional1555096in__structional_
international1357676inte__rnational_
internationals1454246inte__rnationals
intonational1256006in___tonational_
investigate15104306investigat_____e
investigated17113916investigat____ed
investigates16104216investigat____es
invocational1754416inv___ocational_
navigational1653296_n__avigational_
negational1147156_n_e___gational_
reinvestigating2071916reinvestigati_n__g
aestivation1447927__aestivation___
aestivations1547487__aestivation__s
annexational1953267anne___xational_
aspirational1455007___aspirational_
castigation1447977__castigation___
castigations1547207__castigation__s
civilizational2871677civ_ilizational_
coinvestigator2091467coinvestigat_o___r
coinvestigators21101387coinvestigat_o__rs
conspirational1853967_conspirational_
constitutional1663097_constitutional_
constitutionals1761877_constitutionals
conversational1954167conve__rsational_
declinational1652927__declinational_
derivational1654267__de_rivational_
destination12413847__destination___
destinations13412667__destination__s
dissertational1562577dissert__ational_
domestication18114547domestication___
domestications19143997domestication__s
estimation12410847___estimation___
estimations1349947___estimation__s
estivation1349817___estivation___
estivations1449277___estivation__s
expectational2452497expect__ational_
fustigation1545217__fustigation___
fustigations1644767__fustigation__s
ideational1146507i_de____ational_
immigrational1851937i___mmigrational_
improvisational2261657improvisational_
inactivation1745097in_activation___
inactivations1854247in_activation__s
indentation1248377indent__ation___
indentations1347887indent__ation__s
inebriation1357247in_ebri_ation___
inebriations1456327in_ebri_ation__s
informational1854347in__formational_
ingratiatingly1961467ingrati_ati_ngly
ingratiation1355807ingrati_ation___
ingratiations1455157ingrati_ation__s
inhalational1553047in___halational_
initiation10412107in__iti_ation___
initiations11410727in__iti_ation__s
innovational1553837in___novational_
inquisitional2272837in__quisitional_
inscriptional17173517in__scriptional_
insemination1446997inse_mination___
inseminations1546247inse_mination__s
insertional1147467in__s__ertional_
inspiration1348377in__spiration___
inspirations1447307in__spiration__s
instigative1555127in__stigati___ve
instigator1146417in__stigat_o___r
instigators1245927in__stigat_o__rs
instillation1245857in__stillation___
instillations1344927in__stillation__s
institution1145297in__stitution___
institutions1244737in__stitution__s
intentional11128847in___t_entional_
interactional1557007inte__ractional_
interdivisional1971727interdivisional_
interjectional23195607inte_rjectional_
internationally1873717inte__rnationally
interregional1453767interreg__ional_
interrogation1457867interrogation___
interrogations1556817interrogation__s
intersectional16146257inte_rsectional_
interstation12410417interst__ation___
interstitial1255637intersti__ti__al_
intestinal1047517intes____ti_nal_
intimation12413047in___timation___
intimations13411887in___timation__s
intuitional1155297in___t_uitional_
invagination1645647inv_agination___
invaginations1755087inv_agination__s
invalidation1646047inv_alidation___
invalidations1745627inv_alidation__s
invigilation1655147inv_igilation___
invigilations1764487inv_igilation__s
invitation13410027inv___itation___
invitations1449057inv___itation__s
involutional1553577inv___olutional_
irrotational1254027i_rrot__ational_
levitational1553637__le_vitational_
mediational1445647__me_di_ational_
misestimation1794727misestimation___
misestimations18144427misestimation__s
motivational1753917___motivational_
multinational1553767__multinational_
multinationals1662227__multinationals
navigationally2162237_n__avigationally
nonsensational1463277_nonsensational_
nonstationary1672137_nonst__ationary
notational1048127_n__ot__ational_
nutational1047047_n__ut__ational_
orchestrational2071877orchest_rational_
orientational1353807orient__ational_
postulational1553917__postulational_
presentational1673217_presentational_
progestational1762757progest__ational_
repetitional1453727repe_ti__tional_
situational1144587____situational_
speciational1654317_spe_ci_ational_
stational948517____st__ational_
substitutional1662047_substitutional_
terminational1553487__terminational_
transpirational1773107transpirational_
unhesitatingly21101657unhes_itati_ngly
unsensational1353667un__sensational_
variational1444787__v_ari_ational_
vegetational1653377__ve_getational_
ventilation1448167__ventilation___
ventilations1547407__ventilation__s
vestigial1343777__vestig__i__al_

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 Filter178691950240.376475242.0
2DLD Change Limit950241538.97010593.5
3Display Results1531530.1231243.9
 (SQL Overall)1786911539.46918871.2
 
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.