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 “interrogatory” 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.

95 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
interrogatory177364(None) 
interrogator1355001interrogator_
interrogators1454281interrogators
interlocutory18152623interlocutory
interpolator1455763interpolator_
interpolators1554853interpolators
interrogate1277613interrogat__e
interrogated1476373interrogat_ed
interrogatee1386213interrogat_ee
interrogatees1494173interrogatees
interrogates1387103interrogat_es
interrogating1556663interrogating
interrogation1457863interrogation
interrogations1556813interrogations
interrogative17104983interrogative
interrogatories1671983interrogatories
derogatory1545114__de_rogatory
integrator1157124integr__ator_
integrators1246524integr__ators
intercountry1753644intercount_ry
interdictory1853764inte_rdictory
interjectory2454514inte_rjectory
interlocutor14143504interlocutor_
interlocutors15153104interlocutors
interrogational1693904interrogational
interrogatively2271964interrogatively
interrogatives18133474interrogatives
interruptor13114054interr_uptor_
interruptors1453604interr_uptors
investigatory2062234investigatory
supererogatory2071134supererogatory
arrogator1045265___arrogator_
arrogators1145385___arrogators
enteropathy1953315ente_ropat_hy
enterostomy1672555ente_ro_stomy
exterminatory2562485exterminatory
impersonator1692735impersonator_
impersonators1792495impersonators
incorporator1653395incorporator_
incorporators1763015incorporators
informatory1953465in_for_matory
ingratiatory1662495in_gratiatory
innovatory1653165in___novatory
inspiratory1654415inspir__atory
intercalary1654735inte_r_calary
interceptor15156555inte_rceptor_
interceptors16115745inte_rceptors
intercessory1753175inte_rcessory
intercounty1654695intercount__y
intercrater1349235inte_rcrater_
interdictor1454745inte_rdictor_
interdictors1554455inte_rdictors
interferometry2261815interferomet_ry
interiority1456965interiorit__y
interjector2055435inte_rjector_
interjectors2155045inte_rjectors
interlunary1453945interluna__ry
intermarry1564155inte_r_ma_rry
interoceptor16134535interoceptor_
interoceptors17144035interoceptors
interorgan1155425interorga___n
interpellator1563645interpellator_
interpellators1662925interpellators
interpolate1369335interpolat__e
interpolated1547485interpolat_ed
interpolates1448575interpolat_es
interpolating1657795interpolating
interpolation1558555interpolation
interpolations1657435interpolations
interpolative1865665interpolative
interrelate11188975interrelat__e
interrelated13167465interrelat_ed
interrelatedly1872295interrelatedly
interrelates12148075interrelat_es
interrelating1457295interrelating
interrelation1358735interrelation
interrelations1457615interrelations
interrobang1453655interroba__ng
interrobangs1552685interroba_ngs
interrogee1147205interrog___ee
interrogees1245655interrog__ees
interrupter13105355interr_upter_
interrupters1484315interr_upters
intersensory1552755inte_rsensory
interstratify1963075interstratify
intimidatory1853385int_imidatory
introductory1862875int_roductory
investigator1652765investigator_
investigators1752465investigators
invocatory1844165in___vocatory
irrigator1045705i___rrigator_
irrigators1145635i___rrigators
reprobatory1853665__reprobatory
rogatory1246155_____rogatory
territory1245115__terr__itory

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.390458182.1
2DLD Change Limit124790958.73314289.5
3Display Results95950.0631507.9
 (SQL Overall)178691959.18619452.5
 
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.