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

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

98 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
interrogatories167198(None) 
interrogators1454282interrogator__s
interrogatees1494173interrogat__ees
interrogates1387103interrogat___es
interrogatives18133473interrogat_ives
interrogator1355003interrogator___
interrogatory1773643interrogator__y
interpolators1554854interpolator__s
interrogate1277614interrogat___e_
interrogated1476374interrogat___ed
interrogatee1386214interrogat___ee
interrogating1556664interrogat__ing
interrogation1457864interrogat__ion
interrogations1556814interrogat_ions
interrogative17104984interrogat__ive
enterogastrones1681125ente_rogastrones
enteropathies1863375ente_ropat_hies
enterostomies1563525ente_ro_stomies
integrators1246525integr__ator__s
interiorities1356705interiorit__ies
interlocutors15153105interlocutor__s
intermarries1454855inte_r_ma_rries
interpolates1448575interpolat___es
interpolator1455765interpolator___
interrelates12148075interrelat___es
interrogational1693905interrogational
interrogatively2271965interrogatively
interrogees1245645interrog____ees
interruptors1453605interr_uptor__s
interstratifies1871115interstratifies
territories1146015__terr__itories
arrogators1145376___arrogator__s
conservatories1962546conse_r_vatories
derogatorily1761656__de_rogatorily
enterogastrone1571126ente_rogastrone_
enterotoxins1952926ente_ro__toxins
heterogameties2072206hete_rogameties
heterogamies1854676hete_roga__mies
heterogonies16104816hete_rog__onies
heterospories1863746hete_ro_spories
impersonators1792496impersonator__s
incorporators1763016incorporator__s
inerrancies1355046in_err__a_ncies
inferiorities1653726inferiorit__ies
integralities1495516integr__alities
integrates111010786integr__at___es
integrator1157126integr__ator___
integrities1247786integr__it__ies
interatomic1553846inte_r__atomi_c
intercalates14117266intercalat___es
interceptors16115736inte_rceptor__s
intercompares19133206interco_mpar_es
intercourses1454596interco___urses
interdictors1554456inte_rdictor__s
interdigitates1662436interdigit_ates
interiorise1148096inte_r___iorise
interiorises1296886inte_r___iorises
interiorizes2155696inte_r___iorizes
interjectors2155046inte_rjector__s
interlocutor14143506interlocutor___
interlocutory18152626interlocutor__y
intermarried1553636inte_r_ma_rried
intermediaries1782526inte_rmediaries
intermixtures2252046inte_rmixtur_es
internalities1358636inte_r_nalities
interoceptors17144036interoceptor__s
interpellators1662926interpellator__s
interpolate1369336interpolat___e_
interpolated1547486interpolat___ed
interpolating1657796interpolat__ing
interpolation1558556interpolat__ion
interpolations1657436interpolat_ions
interpolative1865666interpolat__ive
interreges1148846interreg_____es
interrelate11188976interrelat___e_
interrelated13167466interrelat___ed
interrelating1457296interrelat__ing
interrelation1358736interrelat__ion
interrelations1457616interrelat_ions
interrobangs1552686interroba___ngs
interrogee1147196interrog_____ee
interrupters1484316interr_upter__s
interruptor13114056interr_uptor___
interstates11710206inte_rstat___es
interstratified197956interstratified
interties9320336inte_r___t__ies
inventories1454706inve____ntories
investigators1752466investigator__s
invitatories1581896in___vitatories
irrigators1145636i___rrigator__s
necrotomies1556456_n_ecro__tomies
neuroanatomies1691986_n_euroanatomies
neuropathies1764106_n_europat_hies
neurotomies1357046_n_euro__tomies
observatories1861676obse_r_vatories
purgatories1463336___pur_gatories
reformatories1862556__reformatories
understories1365566unde_r__stories

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.360496363.9
2DLD Change Limit95024988.06311785.2
3Display Results98980.0761289.5
 (SQL Overall)178691988.49921024.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.