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

108 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
outprices133762(None) 
outprice1238271outprice_
outpriced1446421outpriced
outbribes1345462outbribes
outcries10313572outcri_es
outdrives1346702outdrives
outpaces122411942outp_aces
outplaces1347742outplaces
outraces102217862out_races
outrides92414992out_rides
outtricks1544322outtricks
outvoices1444422outvoices
outwrites1238232outwrites
auspices1236443ausp_ices
caprices1439893_caprices
cuprites1259023cu_prites
matrices12312083mat_rices
misprices1547913misprices
murices112612283mu__rices
nutpicks1643423nutp_icks
oratrices1145833oratrices
orrices9129363o__rrices
ostriches1446633ost_riches
outargues1044873outargues
outbraves1436713outbraves
outbribe1246253outbribe_
outbribed1445003outbribed
outchides1546793outchides
outcried1139543outcri_ed
outdances12198503outdances
outdrinks1443683outdrinks
outdrive1236893outdrive_
outdriven1344323outdriven
outfaces132311393out_faces
outfences1456463outfences
outfires1139863out_fires
outflies11310153outfli_es
outgives12218623out_gives
outgrins979823outgri_ns
outguides1145413outguides
outkicks1344603out_kicks
outlies72421993out_li_es
outlines82418093out_lines
outlives112511763out_lives
outoffices1851313outoffices
outpace112613023outp_ace_
outpaced13269793outp_aced
outpaints1145283outpaints
outpasses1146613outpasses
outpitches1743063outpitches
outpities1148623outpities
outplace1257913outplace_
outplaced1446353outplaced
outpoints1145703outpoints
outprayed1545753outprayed
outprays13236933outpr_ays
outpreaches1842403outpreaches
outpreen1046913outpr_een
outpreens1144603outpreens
outpress10118183outpr_ess
outpresses12157253outpresses
outpricing1547003outpricing
outproduces1652643outproduces
outpromises1552253outpromises
outpunches1742823outpunches
outpursues1242633outpursues
outpushes1445253outpushes
outrace92418553out_race_
outraced112414203out_raced
outrages92215933out_rages
outraises9311023outraises
outrances112912113outrances
outrates82421373out_rates
outraves112313833out_raves
outride82615683out_ride_
outrider92410563out_rider
outriders10237223out_riders
outrigs82811263out_ri_gs
outrings92811053out_rings
outrocks1437903out_rocks
outshines1238613outshines
outsides92513233out_sides
outsizes172311083out_sizes
outslicks1543823outslicks
outsmiles1146443outsmiles
outsprings1343953outsprings
outsprints1243573outsprints
outstrides1154743outstrides
outstrives1374253outstrives
outtrades1077693outtrades
outtrick1445573outtric_k
outtricked1743693outtricked
outvies102214243out_vi_es
outvoice1344793outvoice_
outvoiced1544403outvoiced
outwiles1139233out_wiles
outwrite1139453outwrite_
overprices17108523overprices
preprices1569263preprices
prices104524543___prices
reprices122913353_reprices
surplices1346043surplices
surprises1137433surprises
surprizes2045593surprizes
trices84826333__t_rices
unpriced1338143_unpriced
uprises92012733_u_prises
utricles1037223_ut_ricles

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411086.61022487.3
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.10925135.9
 
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.