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

47 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
interiorities135670(None) 
inferiorities1653721inferiorities
exteriorities2053632exteriorities
interiorises1296882interiori_ses
interiorizes2155682interiori_zes
incuriosities1552653incuriosities
integrities1247783inte__grities
interiorise1148093interiori_se_
interiorised1355183interiori_sed
interiorising14144913interiorising
interiority1456953interiorit__y
interiorize2056333interiori_ze_
interiorized2254573interiori_zed
interiorizing23144973interiorizing
internalities1358633internalities
posteriorities1661853posteriorities
superiorities1556323superiorities
apriorities1345404__apriorities
deteriorates1354444deteriorat_es
exteriorises1954214exteriori_ses
exteriorizes2853614exteriori_zes
incorporeities1862774incorporeities
infelicities1755104infeli_cities
inferiority1753134inferiorit__y
infertilities1656214infertilities
inheritrices1752744inheritri_ces
inheritrixes2252114inheritri_xes
insecurities1453954inse_curities
integralities1495514integralities
intensities11108914inte__nsities
interiorization2464784interiorization
interiors9513564interior____s
intermarries1454854intermar_ries
interpolates1448574interpolat_es
interposition1586054interposition
interpositions1685124interpositions
interrogatees1494174interrogatees
interrogates1387104interrogat_es
interrogatives18133474interrogatives
interties9320334inte___r_ties
intrepidities16122814intrepidities
inverities13410624inve___rities
materialities1566394materialities
nervosities1454674_n_ervosities
priorities1249154___priorities
seniorities1148124__seniorities
sterilities11129014_steri_lities

Search took 6 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.1231452772.4
2DLD Change Limit95024475.78316431.6
3Display Results47470.0301566.7
 (SQL Overall)178691475.93630102.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.