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

72 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
preshowed187518(None) 
reshowed15117061_reshowed
foreshowed2044062foreshowed
prescored14409402prescored
preshaped1745522preshaped
preshow15237412preshow__
preshown16255632preshow_n
preshows16267012preshow_s
prestored125111672prestored
reshoed112212152_resho_ed
reshower14107062_reshower
resowed113712252_res_owed
besnowed14124403_besnowed
bestowed14156613_bestowed
frescoed1436053fresco_ed
freshed143312593fresh__ed
freshened1645253freshened
prebooked1863913prebooked
prechose15129773prechose_
prechosen16116243prechosen
precoded1438863pre_coded
precooked1844993precooked
precooled1446363precooled
preowned1435213pre__owned
presaged1238803pres_aged
prescore124812353prescore_
prescores133912163prescores
presented12311613presented
preserved15107553preserved
preshape1537533preshape_
preshapes1667083preshapes
preshipped1742963preshipped
preshowing1944463preshowing
presided12410553pres_ided
presifted1536873presifted
presliced1435973presliced
presoaked1635653presoaked
presold1059603pres_o_ld
presolved1545273presolved
presorted1239453presorted
pressed103317303pres__sed
pressured1237323pressured
prestore104217343prestore_
prestores114716063prestores
presumed1337963pres_umed
previewed1843413previewed
prisoned1138813pris_oned
pshawed16103033p__shawed
reavowed1534673_reavowed
rechewed1735633_rechewed
reflowed15126903_reflowed
reglowed13125853_reglowed
replowed14127563_replowed
resawed113111183_res_awed
rescored114513103_rescored
resewed113011823_res_ewed
reshaped1437203_reshaped
reshaved1536873_reshaved
reshined123011123_reshined
reshod103012233_resho__d
reshoe92816483_resho_e_
reshoes102316033_resho_es
reshone102414163_reshone_
reshow123111433_reshow__
reshowered1752913_reshowered
reshowers15145473_reshowers
reshown13257903_reshow_n
reshows132510453_reshow_s
resoled84119283_res_oled
restoked135710533_restoked
restored96417193_restored
showed135016963___showed

Search took 9 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.250714764.0
2DLD Change Limit148641727.81319024.8
3Display Results72720.0332181.8
 (SQL Overall)178691728.09622071.5
 
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.