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

93 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
interlocking195490(None) 
interlacing1449052interlac_ing
interlinking1755052interlinking
interlooping1554312interlooping
interloping1446962interlo_ping
interworking2054522interworking
interacting14411713inter_acting
interarching1845013interarching
interdicting1647453interdicting
interfacing1747703interfac_ing
interflowing1953663interflo_wing
interfolding1754583interfolding
interjecting2248393interjecting
interjoining2054653interjoining
interlapping1754033interlapping
interlarding1445563interlarding
interlaying1547573interl_aying
interleaving1676163interleaving
interlending1456413interlending
interleukin1554453interleukin_
interleukins1654143interleukins
interlining1249133interl_ining
interlock1546233interlock___
interlocked1854543interlock_ed
interlocks1645973interlock__s
interposing1447803interpo_sing
intersecting1549713intersecting
interworkings2152483interworkings
fingerpicking2661184fingerpicking
forelocking2142594fore_locking
interbedding1754484interbedding
interceding1568044inter_ceding
intercepting1748874intercepting
intercropping2052804intercropping
intercrossing1653144intercrossing
intercutting1545944intercutting
interesting12411124inter_esting
interfacings1854354interfac_ings
interfering1558924inter_fering
interfiling1546954inter_filing
interfusing1555834inter_fusing
intergrading1545984intergrading
interiorising14144914interiorising
interiorizing23144974interiorizing
interjoin1647894interjo__in_
interjoins1747954interjo__ins
interknotting1852664interknotting
interlayering1753054interlayering
interline91218004interl___ine
interlinings1355064interl_inings
interlink131310664interl___ink
interloan948774interlo__an_
interloans1048264interlo__ans
interlocal1247094interloc__al
interlocutor14143504interlocutor
intermatting1547174intermatting
intermeshing1855054intermeshing
intermitting1547254intermitting
intermixing2146614inter_mixing
internecine1367874internec_ine
interning10315254inter___ning
interocean1246484inter_ocean_
interplanting1655344interplanting
interplaying1845514interplaying
interpleading1754204interpleading
interpoint12411884interpo__int
interpolating1657794interpolating
interpreting1588304interpreting
interring10315424inter___ring
interrobang1453654interro_bang
interrogating1556664interrogating
interrupting1546244interrupting
interspacing1755054interspacing
intertilling1355374intertilling
intertwining1654224intertwining
intervening1548174inter_vening
interviewing1964244interviewing
interweaving1985164interweaving
inthroning1446224inthr_o_ning
intrenching1744074int_renching
introfying1744854int_r_ofying
outrocking1747054out_r_ocking
overlooking1945414_overlooking
relocking16137684__re_locking
trocking153612424__t_r_ocking
unblocking1943694un__blocking
undercooking2063244undercooking
underloading1564294underloading
underworking2153454underworking
unfrocking2043534un_fr_ocking
unlocking1636074un___locking
untracking1746934unt_r_acking
waterlogging1851554waterlogging

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 Filter1786911247900.390458182.1
2DLD Change Limit124790937.26617174.5
3Display Results93930.0631476.2
 (SQL Overall)178691937.71923149.5
 
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.