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

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

146 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
investigational196193(None) 
investigation1754082investigation__
investigations1853722investigation_s
investigating1853343investigati_n_g
inspirational1554404in__spirational
instigation1249244in__stigation__
instigations1348244in__stigation_s
institutional1353494in__stitutional
interrogational1693904interrogational
investigative2062634investigati__ve
investigator1652764investigat_o__r
investigators1752464investigat_o_rs
investigatory2062234investigat_o_ry
invitational1554894inv___itational
reinvestigation1962184reinvestigation__
antinational1297455an___tinational
antirational1278455an___tirational
gestational1245115__gest__ational
illustrational1461555illust_rational
incantational1553565incant__ational
inclinational1553925in__clinational
indicational1545745in___dicational
infestation1447045infest__ation__
infestations1546625infest__ation_s
instigating1347155in__stigati_n_g
instructional1555085in__structional
international1357665inte__rnational
intonational1256005in___tonational
investigate15104305investigat____e
investigated17113915investigat___ed
investigates16104215investigat___es
invitationals1652735inv___itationals
invocational1754415inv___ocational
navigational1653285_n__avigational
negational1147155_n_e___gational
reinvestigating2071915reinvestigati_n_g
aestivation1447926__aestivation__
aestivations1547486__aestivation_s
annexational1953266anne___xational
aspirational1454996___aspirational
castigation1447976__castigation__
castigations1547206__castigation_s
civilizational2871666civ_ilizational
coinvestigator2091466coinvestigat_o__r
coinvestigators21101386coinvestigat_o_rs
conspirational1853956_conspirational
constitutional1663086_constitutional
conversational1954156conve__rsational
declinational1652926__declinational
derivational1654266__de_rivational
destination12413846__destination__
destinations13412666__destination_s
dissertational1562576dissert__ational
domestication18114546domestication__
domestications19143996domestication_s
estimation12410846___estimation__
estimations1349946___estimation_s
estivation1349816___estivation__
estivations1449276___estivation_s
expectational2452496expect__ational
fustigation1545216__fustigation__
fustigations1644766__fustigation_s
ideational1146496i_de____ational
immigrational1851926i___mmigrational
improvisational2261656improvisational
inactivation1745096in_activation__
inactivations1854246in_activation_s
indentation1248376indent__ation__
indentations1347886indent__ation_s
inebriation1357246in_ebri_ation__
inebriations1456326in_ebri_ation_s
informational1854336in__formational
ingratiation1355806ingrati_ation__
ingratiations1455156ingrati_ation_s
inhalational1553046in___halational
initiation10412106in__iti_ation__
initiations11410726in__iti_ation_s
innovational1553836in___novational
inquisitional2272826in__quisitional
inscriptional17173506in__scriptional
insemination1446996inse_mination__
inseminations1546246inse_mination_s
insertional1147456in__s__ertional
inspiration1348376in__spiration__
inspirationally2072536in__spirationally
inspirations1447306in__spiration_s
instigative1555126in__stigati__ve
instigator1146406in__stigat_o__r
instigators1245916in__stigat_o_rs
instillation1245846in__stillation__
instillations1344926in__stillation_s
institution1145296in__stitution__
institutionally1872136in__stitutionally
institutions1244736in__stitution_s
intentional11128836in___t_entional
interactional1556996inte__ractional
interdivisional1971726interdivisional
interjectional23195596inte_rjectional
internationals1454236inte__rnationals
interregional1453756interreg__ional
interrogation1457866interrogation__
interrogations1556816interrogation_s
intersectional16146246inte_rsectional
interstation12410416interst__ation__
interstitial1255636intersti__ti__al
intestinal1047516intes____ti_nal
intimation12413046in___timation__
intimations13411886in___timation_s
intuitional1155286in___t_uitional
invagination1645646inv_agination__
invaginations1755086inv_agination_s
invalidation1646046inv_alidation__
invalidations1745626inv_alidation_s
invigilation1655146inv_igilation__
invigilations1764486inv_igilation_s
invitation13410026inv___itation__
invitations1449056inv___itation_s
involutional1553576inv___olutional
irrotational1254026i_rrot__ational
levitational1553636__le_vitational
mediational1445636__me_di_ational
misestimation1794726misestimation__
misestimations18144426misestimation_s
motivational1753906___motivational
multinational1553756__multinational
nonsensational1463276_nonsensational
notational1048126_n__ot__ational
nutational1047046_n__ut__ational
orchestrational2071876orchest_rational
orientational1353796orient__ational
postulational1553916__postulational
presentational1673216_presentational
progestational1762756progest__ational
repetitional1453726repe_ti__tional
situational1144586____situational
speciational1654316_spe_ci_ational
stational948516____st__ational
substitutional1662046_substitutional
terminational1553486__terminational
transpirational1773096transpirational
unsensational1353666un__sensational
variational1444776__v_ari_ational
vegetational1653376__ve_getational
ventilation1448166__ventilation__
ventilations1547406__ventilation_s
vestigial1343776__vestig__i__al

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 Filter178691950240.1261418182.5
2DLD Change Limit950241468.61011036.5
3Display Results1461460.1061377.4
 (SQL Overall)1786911468.84220209.3
 
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.