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

131 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
interrogators145428(None) 
interrogator1355001interrogator_
interrogatory1773641interrogatory
interpolators1554852interpolators
interrogatees1494172interrogatees
interrogates1387102interrogat_es
interrogations1556812interrogations
interrogatories1671982interrogatories
integrators1246523integr__ators
interlocutors15153103interlocutors
interpolator1455763interpolator_
interrogate1277613interrogat__e
interrogated1476373interrogat_ed
interrogatee1386213interrogat_ee
interrogating1556663interrogating
interrogation1457863interrogation
interrogative17104983interrogative
interrogatives18133473interrogatives
interruptors1453603interr_uptors
arrogators1145374___arrogators
impersonators1792494impersonators
incorporators1763014incorporators
integrator1157124integr__ator_
interceptors16115744inte_rceptors
interdictors1554454inte_rdictors
interjectors2155044inte_rjectors
interlocutor14143504interlocutor_
interlocutory18152624interlocutory
interoceptors17144034interoceptors
interpellators1662924interpellators
interpolates1448574interpolat_es
interpolations1657434interpolations
interrelates12148074interrelat_es
interrelations1457614interrelations
interrobangs1552684interroba_ngs
interrogational1693904interrogational
interrogees1245654interrog__ees
interrupters1484314interr_upters
interruptor13114054interr_uptor_
investigators1752464investigators
irrigators1145634i___rrigators
abrogators1345235___abrogators
alternators1154105alte_r_nators
arrogator1045255___arrogator_
derogatory1545115__de_rogatory
determinators1653895determinators
enervators1345705en_e_r_vators
exterminators2252965exterminators
heteroatoms1654945hete_ro_atoms
heterogamous1863805hete_rogamous
imperators1447715impe_r__ators
impersonator1692735impersonator_
incorporator1653395incorporator_
indagators1244155in___dagators
inheritors1345635inhe_r__itors
innovators1344145in___novators
inseminators1453765inse_minators
inspirators1345555inspir__ators
instigators1245925in__stigators
integrates111010785integr__at_es
integrations13129475integr__ations
interbehaviors2261405interbehaviors
intercalates14117265intercalat_es
intercalations1655915intercalations
intercepters16126405inte_rcepters
interceptor15156555inte_rceptor_
intercessors1453885inte_rcessors
intercoolers1454455interco_olers
intercostals1454615interco_stals
intercountry1753645intercount_ry
intercrater1349235inte_rcrater_
interdictor1454745inte_rdictor_
interdictory1853765inte_rdictory
interferometers20141905interferometers
intergradations17123455intergradations
intergrowths1952125intergro_wt_hs
interiorities1356705interiorities
interiors9513575inte_r___iors
interjector2055435inte_rjector_
interjectory2454515inte_rjectory
interlayers1445335inte_r_layers
interloans1048265interlo_a__ns
interloops1245485interlo___ops
interlopers1346195interlo__pers
intermats111412455inte_r_mat__s
intermitters1454605inte_rmitters
interoceptor16134535interoceptor_
interorgan1155425interorga___n
interpellator1563645interpellator_
interpleaders1652665interpleaders
interpolate1369335interpolat__e
interpolated1547485interpolat_ed
interpolating1657795interpolating
interpolation1558555interpolation
interpolative1865665interpolative
interposers1346265interpo__sers
interpositions1685125interpositions
interpretations17134805interpretations
interpreters1456185inte_rpreters
interreges1148845interreg___es
interregnums1552005interreg_nums
interrelate11188975interrelat__e
interrelated13167465interrelat_ed
interrelating1457295interrelating
interrelation1358735interrelation
interrobang1453655interroba__ng
interrogatively2271965interrogatively
interrogee1147205interrog___ee
interrupter13105355interr_upter_
interruptions1565735interruptions
interrupts1245745interr_upt__s
interstates11710205inte_rstat_es
intervenors14105475inte_r_venors
intimidators1554165int_imidators
invertors12239795inve_r___tors
investigator1652765investigator_
investigatory2062235investigatory
invigorators1653145in_vigorators
irrigator1045705i___rrigator_
irritators1045135i___rritators
literators1048105lite_r__ators
narrators947865_n_arr__ators
negators92411175_n_e___gators
nitrators949215nit__r__ators
percolators1545365__percolators
perforators1644855__perforators
perorators1249355__pe_rorators
personators1345545__personators
sternutators1251505_sternutators
supererogatory2071135supererogatory
terminators1346035__terminators

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 Filter1786911247900.423422437.4
2DLD Change Limit1247901318.23315157.3
3Display Results1311310.0931408.6
 (SQL Overall)1786911318.74920424.2
 
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.