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

94 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
outswear114479(None) 
outswears1244301outswears
outwear1097711out_wear
outerwear1242572outerwear
outhear10910602out_hear
outsoar739492outs_oar
outspeak1454582outspeak
outsteer837552outsteer
outswam1246612outsw_am
outsware11168842outsw_are
outsweep1344912outsweep
outswept1346382outswept
outwar91011512out_w_ar
outwears1197262out_wears
outweary1485392out_weary
unswear1035002_unswear
antiwear1146123antiwear
footwear14103373foot_wear
foreswear1543513foreswear
forswear1443293forswear
gutsier8389823gutsie_r
menswear1352173menswear
nutsier7329253nutsie_r
ouster64223733ou_ste_r
outbeam1137973out_beam
outbleat1048423outbleat
outbreak1444773outbreak
outcheat1349413outcheat
outdoer849273outdoe_r
outdream1144713outdream
outearn7310683out__earn
outeat62824533out__eat
outer55633303out__e_r
outgleam1153633outgleam
outheard1288543out_heard
outhears11810393out_hears
outlead83311103out_lead
outleap9298293out_leap
outlearn836433out_learn
outlier72216143outlie_r
outpower1336673outpowe_r
outread82811093out_read
outroar739513out_roar
outsat62920283outs__at
outsavor1194253outsavor
outsaw92610283outs__aw
outsay92611873outs__ay
outscream1343113outscream
outsee63121803outs_e_e
outseen72712333outs_een
outsees72616433outs_ees
outsell7109263outs_ell
outsert72819513outs_ert
outset64027453outs_e_t
outsets73514923outs_ets
outsider9269643outsider
outsleep1046013outsleep
outslept1047703outslept
outsmart10168923outs_mart
outsmell1075523outsmell
outsmelt10138163outsmelt
outsoars838853outs_oars
outspan938743outs_pan
outspeaks1554013outspeaks
outsped101110323outspe_d
outspeed11117933outspeed
outspell10125453outspell
outspelt10148403outspelt
outspend11126203outspend
outspent101310213outspent
outspread1243503outspread
outstare81410693outs_tare
outstart81611283outs_tart
outstay1047683outs_tay
outsteers936033outsteers
outswearing1544073outswearing
outsweeps1443193outsweeps
outswim1244843outsw_im
outswims1344393outswims
outswing1259283outswing
outswore11168673outswore
outsworn11166663outsworn
outswum1244563outsw_um
outswung1253793outswung
outtower1136193outtowe_r
outward11811403out_w_ard
outwars10912793out_w_ars
outweep1236673out_weep
outwent10311363out_went
outwept1237933out_wept
overwear14248603overwear
sportswear1551343sportswear
swear85316853___swear
unswears1144023_unswears

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.186960704.3
2DLD Change Limit146162946.90621164.5
3Display Results94940.0332848.5
 (SQL Overall)178691947.12525079.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.