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 “items” 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
items749961(None) 
item65620381item_
stems75219951stems
ates45047922ate_s
atoms76817562atoms
biters83925232biters
bites75641172bite_s
citers85022972citers
cites74435582cite_s
deems85421772deems
dites66339152dite_s
ems56435492__ems
fems96428702_fems
gems75329112_gems
gites65630182gite_s
haems105517012haems
hems95534942_hems
ices66129642ice_s
ideas65919012ideas
idem76121062idem_
ides57734232ide_s
ileus54616892ileus
imams91511102imams
inters64328042inters
ires45639282ire_s
isms66213472i_sms
itemed936602itemed
itemise997452itemise
its35538832it__s
kiters105218582kiters
kites95432542kite_s
liters65429872liters
mems85931502_mems
miters84328772miters
mites75141802mite_s
neems77316292neems
niters64624202niters
nites55736342nite_s
poems95715552poems
rems66237722_rems
retems83914572retems
rites54442552rite_s
seems75525022seems
sites56045432site_s
steams84916902steams
stem610628242stem_
steps76619882steps
stets55423912stets
stews85519142stews
stums75320082stums
tams67247932_tams
teams75726512_teams
teas45851492_teas
teds54932572_teds
teems76019782teems
tees45353582_tees
tegs56031492_tegs
tels46841692_tels
temp85323332_temp
temps95417132_temps
tens45647412_tens
terms75523472_terms
tets45847452_tets
tews76431642_tews
tiers55526522tiers
ties45248312tie_s
times75630822times
titers64526402titers
toms68343492_toms
totems86810762totems
utes45930882ute_s
wites85536962wite_s
ylems1039262ylems

Search took 5 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 Filter178691538000.186960704.3
2DLD Change Limit53800734.15612945.1
3Display Results73730.0501460.0
 (SQL Overall)178691734.39240685.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.