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

87 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
interrogating155666(None) 
interpolating1657792interpolating
interrelating1457292interrelating
interrogation1457862interrogation
interrogations1556812interrogations
interrogative17104982interrogative
integrating1349493integr__ating
intercalating1656503intercalating
interrobang1453653interroba__ng
interrogate1277613interrogat__e
interrogated1476373interrogat_ed
interrogatee1386213interrogat_ee
interrogatees1494173interrogatees
interrogates1387103interrogat_es
interrogational1693903interrogational
interrogatives18133473interrogatives
interrogator1355003interrogat_or
interrogators1454283interrogators
interrogatory1773643interrogatory
interrupting1546243interr_upting
arrogating121778394___arrogating
derogating1348634__de_rogating
deteriorating1553394deteriorating
impersonating1873204impersonating
incorporating1854124incorporating
inebriating1446054in_ebr_iating
innervating1546364inne_r_vating
intenerating1346724inte_nerating
interacting14411714inte_r_acting
intercepting1748874inte_rcepting
intercomparing2162284intercomparing
intercropping2052804intercro_pping
intercrossing1653144intercro_ssing
intercutting1545944inte_rcutting
interdicting1647454inte_rdicting
interdigitating1862044interdigitating
interesting12411124inte_r_esting
interfacing1747704inte_r_facing
interfolding1754584interfo_lding
intergang11117884inte_r_ga__ng
intergrading1545984inte_rgrading
intergrafting1854144intergrafting
interiorising14144914interiorising
interiorizing23144974interiorizing
interjecting2248394inte_rjecting
interjoining2054654interjo_ining
interknitting1853284interknitting
interknotting1852664interknotting
interlacing1449054inte_r_lacing
interlaying1547574inte_r_laying
interleaving1676164inte_rleaving
interlocking1954904interlo_cking
interlooping1554314interlo_oping
interloping1446964interlo__ping
intermatting1547174inte_rmatting
intermediating1853984intermediating
intermitting1547254inte_rmitting
interorgan1155424interorga__n_
interpellating1754534interpellating
interpermeating2063074interpermeating
interplanting1655344interplanting
interplaying1845514inte_rplaying
interpleading1754204interpleading
interpolation1558554interpolation
interpolations1657434interpolations
interpolative1865664interpolative
interposing1447804interpo__sing
interpreting1588304inte_rpreting
interrelation1358734interrelation
interrelations1457614interrelations
interring10315424interr____ing
interrobangs1552684interroba__ngs
interrogatively2271964interrogatively
interrogatories1671984interrogatories
intersecting1549714inte_rsecting
interspacing1755054inte_rspacing
intertwisting1753314intertwisting
interweaving1985164inte_rweaving
interworking2054524interwo_rking
intonating1148634int___onating
intreating11614014int__r_eating
investigating1853344investigating
irrigating1245954i___rrigating
iterating10314254i_te_r__ating
surrogating13194324__surrogating
undercoating1645374underco_ating
underrating1388254underr__ating

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 Filter178691950240.1261418182.5
2DLD Change Limit95024877.15313284.5
3Display Results87870.360241.7
 (SQL Overall)178691877.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.