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]

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

65 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
international1357673inte_r_national
interregional1453763interreg__ional
interrogating1556663interrogati_n_g
interactional1557004inte_r_actional
interjectional23195604inte_rjectional
internationals1454244inte_r_nationals
interpolation1558554interpolation__
interpolations1657434interpolation_s
interrelation1358734interrelation__
interrelations1457614interrelation_s
interrogative17104984interrogati__ve
interrogatively2271964interrogatively
interrogatives18133474interrogati_ves
interrogator1355004interrogat_o__r
interrogators1454284interrogat_o_rs
interrogatory1773644interrogat_o_ry
intersectional16146254inte_rsectional
intonational1256004int___onational
investigational1961934investigational
irrotational1254024i___rrotational
aberrational1453485_aberr__ational
antirational1278495ant_ir__ational
hyperrational2153935hyperr__ational
informational1854345in_for_mational
innovational1553835in___novational
insertional1147465inse_r___tional
inspirational1554415inspir__ational
insurrectional1662605insurr_ectional
integration121310495integr__ation__
integrations13129475integr__ation_s
intentional11128855inte____ntional
interbehavioral237955interbehavioral
intercalation1557085intercalation__
intercalations1655915intercalation_s
intercessional1663645inte_rcessional
intercortical1764425interco_rti_cal
interdivisional1971725interdivisional
intergradation16114095intergradation__
intergradations17123455intergradation_s
internationally1873715inte_r_nationally
interpolating1657795interpolati_n_g
interposition1586055interposition__
interpositions1685125interposition_s
interpretation16115865interpretation__
interpretations17134805interpretation_s
interracial1357075interr__aci__al
interrelating1457295interrelati_n_g
interrogate1277615interrogat____e
interrogated1476375interrogat___ed
interrogatee1386215interrogat___ee
interrogatees1494175interrogat__ees
interrogates1387105interrogat___es
interrogatories1671985interrogatories
interruption1466405interr_uption__
interruptions1565735interr_uption_s
interstation12410415inte_rstation__
invocational1754415in___vocational
irrational1047215i___rr__ational
narrational1145445_n_arr__ational
negational1147155_n_e___gational
perorational1446395__pe_rorational
terminational1553485__terminational

Search took 5 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 Filter178691658740.310576422.6
2DLD Change Limit65874654.44014836.5
3Display Results65650.0461413.0
 (SQL Overall)178691654.79637258.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.