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

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

73 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
posits8571871(None) 
posies84431431posies
posit75833331posit_
posts75228781pos_ts
cosets85824402cosets
cosies84932162cosies
costs77231142cos_ts
deposits1138842deposits
doits66223672do_its
eosins64419162eosins
exposits1747242exposits
foists95413982foists
hoists95516022hoists
hosts85526702hos_ts
joists134711032joists
mosts76028542mos_ts
obits74617552_obits
omits75018262_omits
opsins8411712opsins
pastis84924322pastis
pasts75936502pas_ts
pests75933272pes_ts
pewits112810682pewits
piosity1268652piosity
pipits104713062pipits
pits66348752p__its
plaits83816472plaits
podite93315352podite
podites103014732podites
poesies93217402poesies
poets76024442po_ets
pogies94123542pogies
points85618532points
pois66539042po_i_s
poises84226542poises
pokies125921332pokies
polies84034582polies
polios84019722polios
polis74731162poli_s
polite83625072polite
polity113015862polity
ponies84833462ponies
popsies112816472popsies
ports75934592po_rts
posers84223972posers
poses74642762pos_es
posing93922642posing
posited10511492posited
posses85128802posses
possets94212772possets
post67953362pos_t_
postie84123962postie
posties93128812posties
postin83521032postin
postins93721202postins
pots66452362po__ts
potsies93019482potsies
poults84613482poults
pouts75530322po_uts
probits112712572probits
profits122911242profits
prosit85124592prosit_
psis68120342p_si_s
ptosis83611822ptosi_s
pyosis114012122pyosi_s
reposits10310452reposits
resits64725562resits
rosets65819952rosets
rosins64521862rosins
sits45050212__sits
toits55327472to_its
visits9311422visits
vomits112610922vomits

Search took 4 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 Filter178691825510.356501941.0
2DLD Change Limit82551733.59622956.3
3Display Results73730.0135615.4
 (SQL Overall)178691733.96545067.1
 
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.