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 “interlacustrine” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
interlacustrine17983(None) 
interacting14411715inter_ac__t_ing
interactive1659635inter_ac__t_ive
intercutting1545945inter__cu_tting
interlacing1449055interlac____ing
interlayering1753055interla__yering
intrauterine1263015int_r_a_uterine
lacustrine1252835_____lacustrine
enterogastrone1571126enter_ogastrone
intellective1754656intellec__t_ive
interactant1357046inter_ac__t_ant
interaction13411816inter_ac__t_ion
interactions14410466inter_ac__tions
interbasin1246856interba__s__in_
intercalating1656506interca_lat_ing
intercaste1249286inter__cast___e
intercepting1748876inter__cept_ing
interculture1454296inter__cult_ure
intercurrent1454356inter__cu_rrent
interdicting1647456interdic__t_ing
interdictive1855316interdic__t_ive
interdistrict1662366inter__district
interelectrode1761966interelec__trode
interelectron1564136interelec__tron_
interesting12411126inter___est_ing
interfacing1747706interfac____ing
interfaculty2052386interfacult___y
interfusing1555836inter__fus__ing
interindustry1761156interindustr__y
interjecting2248396interjec__t_ing
interlace11311916interlac______e
interlacement1753486interlac__ement
interlaces12412056interlaces_____
interlapping1754036interla___pping
interlarding1445566interla___rding
interlaying1547576interla____ying
interleukin1554456interl_eu__kin_
interleukins1654146interl_eu__kins
interline91218016interl______ine
interlocking1954906interloc___king
interlocutor14143506interlocu_t__or
interlocutors15153106interlocu_t_ors
interlocutory18152626interlocu_t_ory
intermatting1547176interma___tting
intermountain1572166inter_mountain_
internalising1455626internalis__ing
internecine1367876internec____ine
interoceptive2074456inter_ocept_ive
interplanting1655346interpla__nt_ing
interrupting1546246inter__rupt_ing
interruptive1754326inter__rupt_ive
intersecting1549716intersec__t_ing
intersterile1254286inter____sterile
interstice1249606inter____st_ice
interstrain1155866inter____strain_
interstrand1254416inter____strand
intertwine1347616inter_____twine
intertwisting1753316inter_twist_ing
intestine9411856inte_____st_ine
intrusting11128176int_r___ust_ing

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 Filter178691950240.360496363.9
2DLD Change Limit95024608.09611737.2
3Display Results60600.0461304.3
 (SQL Overall)178691608.50221017.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.