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 “interrogational” 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.

201 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
interrogational169390(None) 
interrogation1457862interrogation__
interrogations1556812interrogation_s
international1357663inte_r_national
interregional1453753interreg__ional
interrogating1556663interrogati_n_g
interactional1556984inte_r_actional
interjectional23195584inte_rjectional
internationals1454234inte_r_nationals
interpolation1558554interpolation__
interpolations1657434interpolation_s
interrelation1358734interrelation__
interrelations1457614interrelation_s
interrogative17104984interrogati__ve
interrogatively2271964interrogatively
interrogatives18133474interrogati_ves
interrogator1355004interrogat_o__r
interrogators1454284interrogat_o_rs
interrogatory1773644interrogat_o_ry
intersectional16146234inte_rsectional
intonational1255994int___onational
investigational1961934investigational
irrotational1254024i___rrotational
aberrational1453485_aberr__ational
antirational1278445ant_ir__ational
hyperrational2153925hyperr__ational
informational1854335in_for_mational
innovational1553835in___novational
insertional1147445inse_r___tional
inspirational1554395inspir__ational
insurrectional1662585insurr_ectional
integration121310495integr__ation__
integrations13129475integr__ation_s
intentional11128835inte____ntional
interbehavioral237955interbehavioral
intercalation1557085intercalation__
intercalations1655915intercalation_s
intercessional1663645inte_rcessional
intercortical1764405interco_rti_cal
interdivisional1971725interdivisional
intergradation16114095intergradation__
intergradations17123455intergradation_s
internationally1873715inte_r_nationally
interpolating1657795interpolati_n_g
interposition1586045interposition__
interpositions1685115interposition_s
interpretation16115865interpretation__
interpretations17134805interpretation_s
interracial1357075interr__aci__al
interrelating1457295interrelati_n_g
interrogate1277615interrogat____e
interrogated1476375interrogat___ed
interrogatee1386215interrogat___ee
interrogatees1494175interrogat__ees
interrogates1387105interrogat___es
interrogatories1671985interrogatories
interruption1466405interr_uption__
interruptions1565715interr_uption_s
interstation12410415inte_rstation__
invocational1754415in___vocational
irrational1047205i___rr__ational
narrational1145435_n_arr__ational
negational1147155_n_e___gational
perorational1446385__pe_rorational
terminational1553485__terminational
aggregational1662226__aggregational
annexational1953266anne___xational
antieducational18101526antieducational
antinational1297456ant___inational
antitraditional16161486antitraditional
arrogation11107446___arrogation__
arrogations12126486___arrogation_s
congregational1863426_congregational
conservational1955336conse_r_vational
conversational1954156conve_r_sational
correlational15113656__correlational
deformational19122976__deformational
derivational1654266__de_rivational
derogation12410396__de_rogation__
derogations1349386__de_rogation_s
deterioration14145286deterioration__
deteriorations15164686deterioration_s
dissertational1562576disse_r_tational
enterogastrone1571126ente_rogastron_e
enterogastrones1681126ente_rogastrones
enterostomal1462726ente_ro_st_omal
generational1354816gene_r__ational
ideational1146486i_de____ational
immigrational1851916immigr__ational
impersonation1764226impersonation__
impersonations1863656impersonation_s
incantational1553566in__cantational
inclinational1553926in__clinational
incorporation17115606incorporation__
incorporations18134846incorporation_s
indicational1545736in___dicational
inebriation1357246in_ebr_iation__
inebriations1456326in_ebr_iation_s
inhalational1553046in___halational
innervation1447446inne_r_vation__
innervations1546926inne_r_vation_s
inscriptional17173506in_scr_iptional
instructional1555076in_str_uctional
integrating1349496integr__ati_n_g
integrationist1583686integr__ationist
inteneration1248626inte_neration__
intenerations1347456inte_neration_s
intensional11146566inte____nsional
interaction13411816inte_r_action__
interactions14410456inte_r_action_s
interanimation16135996interanimation__
interanimations17115176interanimation_s
intercalating1656506intercalati_n_g
interception1649376inte_rception__
interceptions1758156inte_rception_s
intercoastal1463986interco_a__stal
intercolonial1563976interco___lonial
intercommunal1962556interco__mmunal
intercostal1365756interco_st___al
interdiction1568146inte_rdiction__
interdictions1667496inte_rdiction_s
interdigitation1763146interdigitation__
interdominion1662636interdominion__
interfacial1656296inte_r_faci__al
interfamilial1862736inte_r_familial
interglacial1554036inte_rglaci__al
interiorization2464786interiorization__
interjection2198926inte_rjection__
interjections2277986inte_rjection_s
interlaminar1453516inte_r_lami_nar
interlineation1455406interlineation__
interlineations1554546interlineation_s
intermarginal1672906inte_r_marginal
intermediation17105216intermediation__
intermediations1894426intermediation_s
intermodulation1893066intermodulation__
interneuronal1362696inte_r_neuronal
interorbital1453616inte_ro_rbi_tal
interorgan1155416interorga___n__
interpellation1665616interpellation__
interpellations1774706interpellation_s
interpersonal1564016inte_r_personal
interpolative1865666interpolati__ve
interpolator1455766interpolat_o__r
interpolators1554856interpolat_o_rs
interpopulation1963596interpopulation__
interproximal2461866interpro__xi_mal
interregna1155076interreg____na_
interrenal1049806interr_____enal
interrobang1453656interroba___n_g
interrobangs1552686interroba___ngs
interrupting1546246interr_upti_n_g
intersection14610186inte_rsection__
intersections1598956inte_rsection_s
intersocietal1562416interso__cietal
interstadial1354086inte_rstadi__al
interstitial1255636inte_r__stitial
interterminal1554296inte_rtermi_nal
intertidal1147706inte_r___ti_dal
intertropical1762736intertro__pi_cal
intervention1568386inte_rvention__
interventions1657506inte_rvention_s
interzonal1946806inte_r____zonal
intestinal1047506inte____sti_nal
intonation10410266int___onation__
intonations1149526int___onation_s
intrazonal1954006int__r__a_zonal
introspectional1972626introspectional
intuitional1155276int____uitional
investigation1754086investigation__
investigations1853726investigation_s
invitational1554896in___vitational
involutional1553576in___volutional
irrationals1154726i___rr__ationals
irrigation1147806i___rrigation__
irrigations1246946i___rrigation_s
iteration9515036i_te_r__ation__
iterations10413826i_te_r__ation_s
maturational1454176mat_ur__ational
navigational1653286_n__avigational
nonrational11109096_n_onr__ational
nonvocational1853686_n_onvocational
notational1048106_n____otational
observational1853176obse_r_vational
operational1347506_ope_r__ational
permutational1752696__permutational
prevocational2054016_pre_vocational
probational1547086____probational
recreational1455166__recr_eational
reformational18113426__reformational
rotational1048086_____rotational
supererogation1763066supererogation__
supererogations1862826supererogation_s
supernational1555616supe_r_national
superregional1662366superreg__ional
ultrarational1363496ult__rarational
unemotional1353486un_e_mo__tional
unsensational1353656unse__nsational
untraditional1463856unt__raditional
winterization25137806winte_rization__
winterizations26157496winte_rization_s

Search took 8 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.1231452772.4
2DLD Change Limit950242017.47012720.7
3Display Results2012010.1401435.7
 (SQL Overall)1786912017.73323107.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.