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

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

102 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
interrogatories1671981interrogatories_
interrogators1454283interrogator__s_
interrogatees1494174interrogat__ees_
interrogates1387104interrogat___es_
interrogatives18133474interrogat_ives_
interrogator1355004interrogator____
interrogatory1773644interrogator___y
interpolators1554855interpolator__s_
interrogate1277615interrogat___e__
interrogated1476375interrogat___e_d
interrogatee1386215interrogat___e_e
interrogating1556665interrogat__i_ng
interrogation1457865interrogat__i_on
interrogational1693905interrogat__ional
interrogations1556815interrogat__ions
interrogative17104985interrogat__i_ve
interrogatively2271965interrogat_ively
enterogastrones1681126ente_rogastrones_
enteropathies1863376ente_ropat_hies_
enterostomies1563526ente_ro_stomies_
integrators1246526integr__ator__s_
interiorities1356706interiorit__ies_
interlocutors15153106interlocutor__s_
intermarries1454856inte_r_ma_rries_
interpolates1448576interpolat___es_
interpolator1455766interpolator____
interrelates12148076interrelat___es_
interrogees1245646interrog____ees_
interruptors1453606interr_uptor__s_
interstratifies1871116interstratifies_
territories1146026__terr__itories_
arrogators1145377___arrogator__s_
conservatories1962547conse_r_vatories_
derogatorily1761657__de_rogatori_ly
enterobacteria1871797ente_robacteri__a
enterogastrone1571127ente_rogastrone__
enterotoxins1952927ente_ro__toxins_
heterogameties2072207hete_rogameties_
heterogamies1854677hete_roga__mies_
heterogonies16104817hete_rog__onies_
heterospories1863747hete_ro_spories_
impersonators1792497impersonator__s_
incorporators1763017incorporator__s_
inerrancies1355057in_err__a_ncies_
inferiorities1653727inferiorit__ies_
integralities1495517integr__alities_
integrates111010787integr__at___es_
integrationist1583687integr__ationi_st
integrator1157127integr__ator____
integrities1247787integr__it__ies_
interatomic1553847inte_r__atomi__c
intercalates14117267intercalat___es_
interceptors16115737inte_rceptor__s_
intercompares19133207interco_mpar_es_
intercourses1454597interco___urses_
interdictors1554457inte_rdictor__s_
interdigitates1662437interdigit_ates_
interiorise1148097inte_r___iori_se
interiorised1355187inte_r___iorised
interiorises1296887inte_r___iorises
interiorizes2155697inte_r___iorizes_
interjectors2155047inte_rjector__s_
interlocutor14143507interlocutor____
interlocutory18152627interlocutor___y
intermarried1553637inte_r_ma_rrie_d
intermediaries1782527inte_rmediaries_
intermixtures2252047inte_rmixtur_es_
internalities1358637inte_r_nalities_
interoceptors17144037interoceptor__s_
interparish1655587inte_r_pa__ri_sh
interpellators1662927interpellator__s_
interpolate1369337interpolat___e__
interpolated1547487interpolat___e_d
interpolating1657797interpolat__i_ng
interpolation1558557interpolat__i_on
interpolations1657437interpolat__ions
interpolative1865667interpolat__i_ve
interreges1148847interreg_____es_
interrelate11188977interrelat___e__
interrelated13167467interrelat___e_d
interrelating1457297interrelat__i_ng
interrelation1358737interrelat__i_on
interrelations1457617interrelat__ions
interrobangs1552687interroba___ngs_
interrogee1147197interrog_____e_e
interrupters1484317interr_upter__s_
interruptor13114057interr_uptor____
interstates11710207inte_rstat___es_
interstratified197957interstratifie_d
interties9320337inte_r___t__ies_
inventories1454707inve____ntories_
investigators1752467investigator__s_
invitatories1581897in___vitatories_
irrigators1145637i___rrigator__s_
necrotomies1556457_n_ecro__tomies_
neuroanatomies1691987_n_euroanatomies_
neuropathies1764107_n_europat_hies_
neurotomies1357047_n_euro__tomies_
observatories1861677obse_r_vatories_
purgatories1463337___pur_gatories_
reformatories1862557__reformatories_
understories1365567unde_r__stories_

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 Filter178691950240.360496363.9
2DLD Change Limit950241028.96610598.3
3Display Results1021020.0801275.0
 (SQL Overall)1786911029.40618997.6
 
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.