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 “predawns” 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
predawns144436(None) 
predawn1335351predawn_
prawns11509022pr__awns
predates11615812predates
prewarns13456942prewarns
redans75421022_reda_ns
bedamns1235733_bedamns
bradawls1443673bradawls
brawns115614083br__awns
cremains1238693cremains
dawns95916593___dawns
dedans85915073_deda_ns
hoedowns15124653hoedowns
ordains879653or_dains
paeans85118263pae_a_ns
paesans93312693paesa_ns
pawns108818133p___awns
peans75437643p_e_a_ns
pecans101515833p_eca_ns
pedalos10329703p_edalos
pedals94316033p_eda_ls
pedant9319493p_eda_nt
pedants10310113p_edants
pekans121710553p_eka_ns
pertains102113423pertains
prawn105312433pr__awn_
preacts113211363pre_acts
preadapts1444003preadapts
preamps1336613pre_amps
prearms11369173pre_arms
prebakes1639013prebakes
precasts1239453precasts
predate10616893preda_te
predated12513273predated
predating13514653predating
predations13812153predations
predatism1447283predatism
predator11310053predator
predators12310083predators
predeaths1544743predeaths
predicts1339613predicts
predries112714383predries
predusks1543423predusks
preens85020113pre__ens
prefabs1435163prefa_bs
prefaces15311063prefaces
prefades1439533prefades
pregames1339003pregames
prelates10418573prelates
prelaw1139103prelaw__
preman104117453prema_n_
prenames12311643prenames
preordains13124523preordains
prepacks1836583prepacks
prepares122014163prepares
prepaves15189193prepaves
prepays1437483prepa_ys
preplans1249613preplans
presages11312203presages
presales10315263presales
pretapes122811533pretapes
preteens1038123preteens
pretrains11410143pretrains
prevails1337663prevails
prewarms15406733prewarms
prewarn124410153prewarn_
prolans9314273prola_ns
putdowns1443523putdowns
redacts10510943_redacts
redan66125013_reda_n_
redates83423873_redates
reddens9259783_reddens
redfins1139923_redfins
redons75222183_red_ons
redowas1138393_redowas
redrawn11245953_redrawn_
redraws11218473_redraw_s
reearns749103_reearns
regains84316583_regains
remains94117913_remains
remans84823003_rema_ns
renowns10277833_renowns
resawn9399953_resawn_
resaws93713513_resaw_s
retains74522253_retains
sedans74816093_seda_ns
treelawns1242043treelawns
trepans92311593trepa_ns

Search took 8 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.420425454.8
2DLD Change Limit146162886.87621256.8
3Display Results88880.0302933.3
 (SQL Overall)178691887.32624391.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.