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

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

84 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
interrogates138710(None) 
interrogate1277611interrogate_
interrogated1476371interrogated
interrogatee1386211interrogatee
interrogatees1494171interrogatees
interpolates1448572interpolates
interrelates12148072interrelates
interrogatives18133472interrogatives
interrogator1355002interrogator
interrogators1454282interrogators
interrogees1245642interrog_ees
integrates111010783integr__ates
intercalates14117263intercalates
interpolate1369333interpolate_
interpolated1547483interpolated
interreges1148843interreg__es
interrelate11188973interrelate_
interrelated13167463interrelated
interrobangs1552683interrobangs
interrogating1556663interrogating
interrogation1457863interrogation
interrogations1556813interrogations
interrogative17104983interrogative
interrogatories1671983interrogatories
interrogatory1773643interrogatory
interrogee1147193interrog__ee
interstates11710203inte_rstates
arrogates10129424___arrogates
derogates11310974__de_rogates
deteriorates1354444deteriorates
impersonates1653894impersonates
incorporates1655234incorporates
inebriates1246064in_ebr_iates
innervates1346394inne_r_vates
integrate10911154integr__ate_
integrated1289294integr__ated
intenerates1148084inte_nerates
intercalate13117704intercalate_
intercalated1596324intercalated
intercompares19133204intercompares
intercostals1454604intercostals
intercourses1454594intercourses
intercrater1349234inte_rcrater
intercrosses1454124intercro_sses
interdigitates1662434interdigitates
interfaces15410414inte_r_faces
intergrades1346784inte_rgrades
intergrowths1952124intergro_wths
interiorises1296884interiorises
interiorities1356704interiorities
interiorizes2155694interiorizes
interlaces12412054inte_r_laces
interleaves1447054inte_rleaves
interloans1048264interlo_a_ns
interlopes1249274interlo__pes
intermats111412454inte_r_mat_s
intermediates1654344intermediates
internodes1148674interno__des
interorgan1155424interorga__n
interpellates1554874interpellates
interpermeates1863464interpermeates
interphases1646154inte_rphases
interpolator1455764interpolator
interpolators1554854interpolators
interposes12410564interpo__ses
interrace11312554interr__ace_
interregnums1552004interregnums
interrobang1453654interroba_ng
interrogatively2271964interrogatively
interrupted1475294interr_upted
interrupter13105354interr_upter
interrupters1484314interr_upters
interrupts1245744interr_upt_s
interspaces1546154inte_rspaces
interstate10710974inte_rstate_
intervales131010514inte_r_vales
interweaves1745684inte_rweaves
intestates10159434inte__states
intonates9410244int___onates
investigates16104214investigates
irrigates1057254i___rrigates
iterates81317824i_te_r__ates
surrogates1144684__surrogates
underrates11410564underr__ates

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 Filter1786911247900.390458182.1
2DLD Change Limit124790847.20317324.7
3Display Results84840.0461826.1
 (SQL Overall)178691847.63923391.9
 
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.