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

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

107 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
interrogative1710498(None) 
interrogatives18133471interrogatives
interpolative1865662interpolative
interrogate1277612interrogat__e
interrogatee1386212interrogat_ee
interrogating1556662interrogating
interrogation1457862interrogation
interrogatively2271962interrogatively
integrative1547123integr__ative
interpretative1993803interpretative
interrogated1476373interrogat_ed
interrogatees1494173interrogatees
interrogates1387103interrogat_es
interrogations1556813interrogations
interrogator1355003interrogat_or
interrogators1454283interrogators
interrogatory1773643interrogatory
interruptive1754323interr_uptive
derogative1546984__de_rogative
deteriorative1762584deteriorative
incorporative20124064incorporative
interactive1659634inte_r_active
interdictive1855314inte_rdictive
interoceptive2074454interoceptive
interoperative1974364interoperative
interpolate1369334interpolat__e
interpolating1657794interpolating
interpolation1558554interpolation
interpretive1775844inte_rpretive
interrelate11188974interrelat__e
interrelating1457294interrelating
interrelation1358734interrelation
interrogational1693904interrogational
interrogatories1671984interrogatories
interrogee1147194interrog___ee
investigative2062634investigative
iterative12410714i_te_r__ative
prerogative1755354_pre_rogative
alternative1454685alte_r_native
anticreative1755045anticr_eative
determinative1954075determinative
ergative1238975___e_r_gative
imperative1748565impe_r__ative
inchoative1854045in__cho_ative
indurative1447285in_dur__ative
informative1965155in_for_mative
innovative1643715in___novative
inoperative1646745inoper__ative
instigative1555125in__stigative
integrate10911155integr__at__e
integrating1349495integr__ating
integration121310495integr__ation
intellective1754655inte_llective
intercalate13117705intercalat__e
intercalating1656505intercalating
intercalation1557085intercalation
interdigitate1562815interdigitate
interfertile1556425inte_rfertile
intergradation16114095intergradation
interiorise1148095interio__rise
interiorities1356705interiorities
interiorize2056335interio__rize
interleave1347615inte_rlea__ve
intermontane1464565intermo_ntane
internalise111510555inte_r_nalise
internalize20149595inte_r_nalize
interoffice1952875inte_ro_ffice
interorgan1155425interorga___n
interpolated1547485interpolat_ed
interpolates1448575interpolat_es
interpolations1657435interpolations
interpolator1455765interpolat_or
interpolators1554855interpolators
interposition1586055interposition
interpretation16115865interpretation
interrace11312555interr__a__ce
interracial1357075interr__acial
interrelated13167465interrelat_ed
interrelates12148075interrelat_es
interrelations1457615interrelations
interrobang1453655interroba__ng
interrobangs1552685interroba_ngs
interrogees1245645interrog__ees
interruptible1762995interr_uptible
interrupting1546245interr_upting
interruption1466405interr_uption
interstate10710975inte_rstat__e
interstation12410415inte_rstation
interstice1249605inte_r__stice
interstratify1963075interstratify
intertie8317615inte_r___ti_e
intervocalic1962945intervocali_c
interweave1646255inte_rwea__ve
interwove1547145interwo____ve
intransitive15124175int_ransitive
irrelative1344785i___rrelative
irritative1345205i___rritative
narrative1247375_n_arr__ative
negative1239085_n_e___gative
neuroactive1653885_n_euroactive
personative1647075__personative
prerogatived1952635_pre_rogatived
prerogatives1853435_pre_rogatives
reintegrative17103255reintegr__ative
reprobative1855645__reprobative
segregative1654065__segregative
terminative1656135__terminative

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 Filter1786911247900.393454684.5
2DLD Change Limit1247901079.39013289.7
3Display Results1071070.0931150.5
 (SQL Overall)1786911079.87618093.5
 
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.