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

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

45 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
intercellular156282(None) 
intracellular1572492intracellular
extracellular2271984extracellular
intercell1148174interce_l_l__
intercultural1563854intercultural
intergranular14141874intergranular
interlobular1462574inter_lobular
interlunar1045434inter___lunar
intermolecular18121984intermolecular
interpellator1563644interpellator
interstellar1252384interstel_lar
intracellularly2091974intracellularly
noncellular1362494_n_oncellular
unicellular1361754un__icellular
acellular1143045____acellular
cellular1045165_____cellular
interallelic1462265inter_allelic
intercalary1654735interc___alary
interceder13198445interce___der
intercensal1356155interce__nsal
intercepter15127925interce__pter
interceptor15156555interce__ptor
intercessor1354335interce__ssor
interclan1148605interc____lan
interclub1344405interc__lu__b
intercluster1453855interc_luster
intercolonial1563985intercolonial
intercommunal1962555intercommunal
intercooler1345835interc__ooler
interculture1454305intercultu_re
interdealer1245765interde__aler
interlinear11145695inter__linear
interlunary1453945inter___lunary
intermeddler1652335interme_ddler
internuclear1492265internucl_ear
interpellate1455415interpell_ate
interpellated1654585interpellated
interpellates1554875interpellates
interpellators1662925interpellators
intersexual1854725interse_xu_al
intertextual1953725intertextu_al
intraocular1353925int_r_aocular
multicellular1771705multicellular
stellular942735_st___ellular
subcellular1561885__subcellular

Search took 10 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 Limit124790458.97013911.9
3Display Results45450.0301500.0
 (SQL Overall)178691459.39019029.9
 
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.