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

54 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
interpellate145541(None) 
interpellated1654581interpellated
interpellates1554871interpellates
interpellator1563642interpellator
interpolate1369332interp_olate
interrelate11188972interre_late
intemperate1555773intempe_rate
intercalate13117703inter_calate
intermediate1554813intermediate
interpellating1754533interpellating
interpellation1665613interpellation
interpellators1662923interpellators
interpermeate1754233interpermeate
interpolated1547483interp_olated
interpolates1448573interp_olates
interrelated13167463interre_lated
interrelates12148073interre_lates
intertillage1352503intertillage
intervillage1652233intervillage
carpellate1445334__carpellate
intenerate1048744inte_ne_rate
intercalated1596324inter_calated
intercalates14117264inter_calates
intercell1148164intercell___
interlace11311914inter___lace
interleave1347614inter__leave
intermediated1753824intermediated
intermediates1654344intermediates
interpellations1774704interpellations
interpenetrate16112994interpenetrate
interpermeated1963214interpermeated
interpermeates1863464interpermeates
interphase1545994interp__hase
interplant12119574interp__lant
interplanted1545054interp_lanted
interplants13116754interp_lants
interplay1447164interp__la_y
interplayed1745244interp__layed
interplays1545524interp__lays
interplead1345604interp_lea_d
interpleaded1654064interp_leaded
interpleader1553784interp_leader
interpleads1444524interp_leads
interpolative1865664interp_olative
interpolator1455764interp_olator
interrogate1277614inter_rogate
interstate10710974inter__state
interstellar1252384interstella_r
intertillages1452224intertillages
interweave1646254interwe__ave
intraplate1255724int_r_aplate
invertebrate1752224invertebrate
terneplate1253784__terneplate
tessellate1052884__tessellate

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 Limit124790547.72016164.5
3Display Results54540.0461173.9
 (SQL Overall)178691548.18921820.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.