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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
preshow1523741(None) 
preshown16255631preshown
preshows16267011preshows
reshow123111431_reshow
foreshow1785892foreshow
peepshow1841412peepshow
preship1439792preship
preshowed1875182preshowed
pressor93512872pressor
presto84216202presto_
prestos93716072prestos
reshod103012232_reshod
reshoe92816482_reshoe
reshot93519632_reshot
reshown13257902_reshown
reshows132510452_reshows
resow88217242_res_ow
airshow1344623airshow
besnow1145713_besnow
bestow1149463_bestow
crenshaw1642423crenshaw
cresol8310203cres_ol
erenow937373ere_now
eyeshot1386543eyeshot
foreshown1864473foreshown
foreshows1875973foreshows
fresco1136473fresco_
frescos1236813frescos
fresh115012203fresh__
freshed143312593freshed
freshen133010883freshen
fresher132612643fresher
freshes133515823freshes
freshet133416643freshet
freshly16286833freshly
parashot13410143parashot
peepshows1951443peepshows
person83517873pers_on
peso66925823p_es_o_
pesos77221623p_es_os
pesto75723723p_esto_
pestos84719083p_estos
plessor9317693plessor
postshow1643043postshow
potshot1249733potshot
prebook1557523prebook
preboom1348243preboom
prechose15129773prechose
precook1577803precook
precool1139013precool
prelaw1139103pre_law
prenoon9310043prenoon
preop94715873pre__op
preriot9316413preriot
presa74319043pres__a
presage10312293presage
presale9416353presale
preschool1643933preschool
prescore124812353prescore
prese75228383pres__e
presell939293presell
present94022723present
preset84430983pres_et
presets94216423presets
preshape1537533preshape
preships1539303preships
preshowing1944463preshowing
preside10715613preside
presift12312223presift
presoak1348453presoak
presold1059603presold
presong1039843presong
presort95219533presort
press75425953pres__s
pressed103317303pressed
presser93717623presser
presses93523153presses
pressors103212673pressors
prest75736353pres__t
prester93519623prester
prestore104217343prestore
prests84021263pres_ts
presume11310303presume
pretor8315743pre_tor
preview1536473preview
prison8514023pris_on
proso77222413pros_o_
prosos85718553pros_os
prow97030383pr___ow
pshaw13447513p__shaw
reavow1235723_reavow
rechew14310213_rechew
reflow12379653_reflow
reglow10339403_reglow
regrow10309883_regrow
replow114210343_replow
resaw84117253_res_aw
resew84519503_res_ew
resh76523453_resh__
reshes94124363_reshes
reship11310673_reship
reshoed112212153_reshoed
reshoes102316033_reshoes
reshone102414163_reshone
reshoot102513893_reshoot
reshowed15117063_reshowed
reshower14107063_reshower
resod64720053_res_od
resown94112923_res_own
resows93915353_res_ows
respot83117633_respot
show106229183___show
sideshow1542423sideshow
supershow1745063supershow
toeshoe1047843toeshoe
trishaw1344753trishaw

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 Filter1786911340270.280638182.1
2DLD Change Limit1340271168.33016089.7
3Display Results1161160.0303866.7
 (SQL Overall)1786911168.64020681.8
 
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.