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

105 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
readmits113665(None) 
preadmits1444921preadmits
readmit1039821readmit_
admits9411412__admits
coadmits1345702coadmits
preadmit1346812preadmit_
readapts1145582readapts
readdicts1343612readdicts
readies83324702read_ies
readopts1146482readopts
readouts938882readouts
reedits8511742reed_its
reemits9611302re_emits
remits85622942re__mits
adits66523713__ad_its
admit8319493__admit_
bedsits1037563be_dsits
bevomits1543463bevomits
breadnuts1243133breadnuts
coadmit1247823coadmit_
credits1039973cre_d_its
deadlifts1443023deadlifts
delimits1137573delimits
demits94918073de__mits
edits65819033_e_d_its
emits75421463_e__mits
headmost1445493headmost
headpins1436103headpins
headsets1236053headsets
hermits12312133he_rmits
permits11314003pe_rmits
preadapts1444003preadapts
preadopts1445123preadopts
preadults1244283preadults
preaudits1265023preaudits
preedits1168763preed_its
prelimits1366003prelimits
rabbits11299863r_abbits
radios74018673r_ad_ios
radius73914863r_ad_ius
ramets83517393r_a_mets
ramies84630463r_a_mies
reacts83616603rea__cts
readapt1039743readapt_
readdict1246153readdict
readding11411363readding
readds84111643read__ds
readers83823763read_ers
readied93316623read_ied
readier83117423read_ier
readiest93719043read_iest
readily11711403read_ily
reading93327213read_ing
readings103512633readings
readjust1644453readjust
readjusts1743043readjusts
readmitted1443463readmitted
readopt10410843readopt_
readorns938273readorns
readout8615493readout_
reads64835273read___s
readying13410223readying
reagents959623reagents
reagins84215643rea_gins
realist73225383rea_list
realists83014833realists
reality10313573rea_lity
reallots837983reallots
realms84913493realm__s
realties8514853realties
reamers94221083rea_mers
reaming103924013rea_ming
reams75729623rea_m__s
reanoints945363reanoints
rearmice1255213rearmice
rearming111413603rearming
rearmost1047263rearmost
rearms85114653rearm__s
reavails1134853reavails
rebaits9312573re_baits
recits83621353re__cits
recommits1544693recommits
recruits1036563recruits
redacts10510943re_dacts
redbaits1135903redbaits
redfins1139923re_dfins
redias74523603re_d_ias
redips93713843re_d_ips
redouts81411653re_douts
redries83721713re_dries
reedit7617223reed_it_
reemit8717223re_emit_
refits94017653re__fits
reknits1137073re_knits
remints95117293re__mints
remiss84216353re__miss
remit75737223re__mit_
reposits10310453reposits
resits64725563re__sits
resplits1037723resplits
resubmits1342793resubmits
revisits1137423revisits
roadies83317433road_ies
treadmill1242383treadmill
treadmills1351953treadmills

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621058.23317753.2
3Display Results1051050.0333181.8
 (SQL Overall)1786911058.43921174.4
 
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.