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

46 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
expositions204684(None) 
exposition1947161exposition_
appositions1546152appositions
depositions14117682depositions
expeditions2144632expeditions
expositing2045352expositi_ng
expositional2153942expositional
expositors1943962exposit_ors
impositions1546032impositions
oppositions1575122oppositions
positions11811502__positions
repositions131110162repositions
apposition1446593apposition_
compositions1846253compositions
deposition13107833deposition_
dispositions1546473dispositions
excoriations2147523excoriations
exfoliations2244783exfoliations
exhibitions2353653exhibitions
expatiations2146133expatiations
expedition2044903expedition_
expeditious2152533expeditious
expiations1959663exp_iations
expirations2069583expirations
explorations2185613explorations
explosions19134663explos__ions
exportations2146653exportations
expositive2254513expositi_ve
expositor1844153exposit_o_r
expository2253143exposit_ory
exposits1747243exposit___s
expunctions2243633expunctions
exsolutions1844013exsolutions
extortions1746473exto_rtions
imposition1446533imposition_
malpositions1653673malpositions
mispositions1655303mispositions
opposition1445483opposition_
ovipositions1753563ovipositions
position10912193__position_
positrons1186543__positrons
prepositions16108303prepositions
propositions16108313propositions
reimpositions1753613reimpositions
reposition121010143reposition_
suppositions1654893suppositions

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 Filter1786911216330.390458182.1
2DLD Change Limit121633465.26623097.8
3Display Results46460.0162875.0
 (SQL Overall)178691465.67231504.1
 
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.