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

78 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
apposite1241001(None) 
opposite1247131opposite
amosite9313162a_mosite
appetite1258492appetite
appose10411992appos__e
apposing1337402apposing
appositely1753132appositely
appositive1744842appositive
inapposite1452552inapposite
opposites1346142opposites
aconite9315473a_conite
adamsite1144423adamsite
adiposity1544103adiposity
aerolite8315053aerolite
ammonite1249143ammonite
amosites10311233a_mosites
andesite949453andesite
apatite9312963a_patite
aphanite1348773aphanite
apholate13410473apholate
aphorise1339983aphorise
aphorize2249043aphorize
aphrodite1545483aphrodite
aplite8316393a_p_lite
apostate1049853a_postate
apostil947903a_postil
apostle937853a_postle
appetites1347513appetites
appoint11612483appo_int
appointed1444803appointed
appointee1345003appointee
appointer1354423appointer
appoints1286403appoints
apposable1545603apposable
apposed1247853appos_ed
apposer1147483appos_er
apposers1236283apposers
apposes11511473appos_es
apposition1446593apposition
appositives1854253appositives
appraise1247703appraise
apprise11310193app_rise
apprize2038183app_rize
approbate1546563approbate
campsite1447413camp_site
composite15410153composite
deposit10313003deposit_
deposited1346773deposited
deposits1138843deposits
exposit1649683exposit_
exposited1945303exposited
exposits1747243exposits
impolite1249293impolite
inosite7314063_inosite
jarosite1548383jarosite
oppose1039193oppos__e
opposing1336383opposing
oppositely1752693oppositely
pappose1047413pappos__e
parasite10314843parasite
piosity1268643_piosity
plosive1236673_plosive
podite93315353__podite
polite83625073__polite
popsie103013053_popsi_e
posit75833333__posit_
posited10511493__posited
posits85718713__posits
postie84123963__postie
prosit85124593_prosit_
prostie91617743_prostie
reposit9315863reposit_
reposited1239133reposited
reposits10310453reposits
riposte9269623ripos_te
saponite10410533saponite
saprolite1147833saprolite
unpolite1049173unpolite

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 Filter1786911461620.420425454.8
2DLD Change Limit146162786.93621073.0
3Display Results78780.0332363.6
 (SQL Overall)178691787.38924183.4
 
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.