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

88 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
preempts144454(None) 
preempt1337721preempt_
preamps1336612preamp_s
precepts14268882precepts
preedits1168762preedits
preemies12512192preemies
preempted1644672preempted
preemptor1544152preemptor
preemptors1644232preemptors
preexempts2351372preexempts
prompts1337472pr_ompts
reemits9611302_reemits
attempts1243103attempts
coempts1335683_coempts
creeps104213623cree_p_s
exempts1844023_exempts
greets75117423gree__ts
kreeps12427413kree_p_s
peeps95822363p_ee_p_s
peewits12105873p_eewits
pelmets11309693p_elmets
percepts14247643percepts
periapts1237273periapts
permits11314003p_ermits
preacts113211363pr_eacts
preadapts1444003preadapts
preadmits1444923preadmits
preadopts1445123preadopts
preamp1238993preamp__
precasts1239453precasts
precents123015033precents
precept133112513precept_
precipes143212213precipes
precuts111710473pr_ecuts
predicts1339613predicts
preedit10512453preedit_
preelects1356083preelects
preemie11310563preem_ie
preempting1745393preempting
preemption16105243preemption
preemptions17134833preemptions
preemptive1944143preemptive
preenacts1345843preenacts
preeners102712813preeners
preens85020113pree__ns
preerects1345413preerects
prees75937173pree___s
preexempt2251893preexempt_
preexist1747963preexist
preexists1844733preexists
preexpose2043703preexpose
prefects1598133prefects
preheats1339413preheats
preimpose1544013preimpose
prelects1299723prelects
prelimits1366003prelimits
premeds12389583pr_emeds
premeet11615153premeet_
premies113823063pr_emies
premiss113513813pr_emiss
preops104911933pr_eop_s
preps96220693pr_e_p_s
prepupas1144133prepupas
presents103315633presents
presets94216423pr_esets
presifts1366593presifts
presorts105311673presorts
prests84021263pr_e_sts
pretapes122811533pretapes
preterits11410943preterits
pretermits1445023pretermits
pretests10310013pretests
pretexts1735603pretexts
pretypes15337253pretypes
prevents133012293prevents
priests93810863prie_sts
primps124711823pr_imp_s
proems104711163proem__s
prompt12313013pr_ompt_
receipts1274693_receipts
recepts113010263_recepts
reedits8511743_reedits
reemit8717223_reemit_
reests64618893_ree_sts
remeets93712413_remeets
remelts93511493_remelts
remits85622943_r_emits
tempts10439453__tempts

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.1561145455.1
2DLD Change Limit146162887.98318309.2
3Display Results88880.0302933.3
 (SQL Overall)178691888.16921874.3
 
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.