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

74 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
prewraps1511405(None) 
prewrap14104971prewrap_
rewraps12136561_rewraps
bewraps14135402_bewraps
prewarms15406732prewarms
prewarns13456942prewarns
rewrap11127532_rewrap_
rewrapt12138112_rewrapt
bewrap13157053_bewrap_
bewrapt14147133_bewrapt
bewrays15145113_bewrays
dewlaps1334663_dewlaps
enwraps1284833_enwraps
firetraps1444303firetraps
inwraps12105253_inwraps
pareiras1038183pareira_s
perhaps1446123p_erhaps
perps95521483p_e_r_ps
petnaps1145033p_etnaps
pleuras937413pleura_s
preadapt1346863preadapt
preadapts1444003preadapts
preamps1336613pre_amps
prearms11369173prear_ms
precrash1544823precrash
predraft1447593predraft
predries112714383predries
prefabs1435163pre_fabs
prefrank1764233prefrank
prefranks1862993prefranks
preheats1339413preheats
preloads1157513preloads
preops104911943pre__ops
preoral9312673preora_l
prepares122014163prepares
prepays1437483pre_pays
preplans1249613preplans
prepregs13144763prepregs
prepress12137983prepress
preps96220693pre___ps
prepupas1144133prepupas
prerace11414123pre_race
preshape1537533preshape
preshapes1667093preshapes
preships1539313preships
presoaks1436603presoaks
prestamps1543523prestamps
pretape113511623pre_tape
pretapes122811533pre_tapes
pretrain10310923pretrain
pretrains11410143pretrains
pretreats1146933pretreats
pretrials1158143pretrials
pretrims1238983pretrims
prewar114712583prew_a_r
prewarm14479613prew_arm
prewarn124410153prew_arn
prewash1535213prew_ash
prewires133811013prewires
preworks17599013preworks
prewrapped1762163prewrapped
procarps1445973procarps
programs1339783programs
reaps75626193_re__aps
recaps103615733_re_caps
redcaps1247073_redcaps
redraws11218473_redraws
remaps105012873_re_maps
rewards114813993_rewards
rewarms12439603_rewarms
rewears102911043_rewears
ripraps1134943_ripraps
unwraps1255513_unwraps
wraps105617153___wraps

Search took 10 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.513348325.5
2DLD Change Limit146162748.61016975.8
3Display Results74740.0332242.4
 (SQL Overall)178691749.15619516.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.