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

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
exteriors164732(None) 
exterior1547371exterior_
extensors1644082extensors
exteriorise1854632exteriorise
exteriorly2083352exteriorly
interiors9513562interiors
anterior8611053anterior_
dexterous1745553dexter_ous
eateries8324313eateri_es
emperors1256123emper_ors
enterers82214153enter_ers
enterics10312853enteri_cs
enteritis9411303enteritis
enterons8314153enter_ons
estriols856253est_riols
evertors1138953e_vertors
excelsiors1952033excelsiors
excerptors2163463excerptors
exertions1639763ex_ertions
expeditors2043643expeditors
exsertions1746743exsertions
extempore2053473extempore
extenders17125673extenders
extensions1746133extensions
extensor1543913extensor_
exteriorised2053193exteriorised
exteriorises1954213exteriorises
exteriority2153673exteriority
exteriorize2753853exteriorize
exteriorizes2853613exteriorizes
extermines1947783extermines
externals1666623externals
externes1539833exter_nes
externs1438233exter__ns
extorters1645763extorters
extortions1746473extortions
extrorse1544553ext_r_orse
inferiors1266543inferiors
interior8513093interior_
posteriors1256813posteriors
stertors8310933_stertors
superiors11410963superiors
termors94712773__termors
terrors73112213__terrors
ulterior845443ulterior_

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 Filter1786911486410.470380193.6
2DLD Change Limit148641457.43619989.4
3Display Results45450.0162812.5
 (SQL Overall)178691457.92222556.3
 
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.