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

219 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
redowas113839(None) 
redowa1038451redowa_
fedoras1137922fedoras
redias74523602red_ias
redocks14409932redocks
redoes74623752redo_es
redons75222182redo_ns
redos65126762redo__s
redouts81411652redouts
redoxes15310882redoxes
redraws11218472redraws
remoras9314072remoras
renowns10277832renowns
resows93915352resow_s
areolas71013863are_olas
bedews12398943bedew_s
bedgowns1543113bedgowns
behowls1534443behowls
belows114614183below_s
cedulas1058503cedulas
credos94612843credo__s
donas65926473__donas
dopas85019063__dopas
downs94918573__downs
dows85941053__dow_s
edemas9310503_edemas
endows104610423endow_s
enows85115493_enow_s
fedora1038593fedora_
genoas74013623geno_as
godowns1234673godowns
hoedowns15124653hoedowns
indows104210793indow_s
judokas1992453judokas
letdowns1243483letdowns
meadows1337333meadow_s
medakas1435763medakas
medias93620783med_ias
medinas103411463medinas
medusas1036213medusas
meows104612683me_ow_s
oedemas1056693oedemas
pedocal1237893pedocal
pedocals1346083pedocals
pelotas9410723pelotas
pesewas1236223pesewas
predawns1444363predawns
radomes10311043radomes
radons74118523rado_ns
radulas839573radulas
ramonas9311093ramonas
readopts1146483readopts
readorns938273readorns
readouts938883readouts
reatas64021013re_atas
reavows1335273reavow_s
reboils94111713reboils
rebooks134010513rebooks
reboots93512093reboots
rebops10311423rebo_ps
rebores95319163rebores
rebozos1835143rebozos
recoal84117973reco_al
recoals94214623recoals
recoat84024273reco_at
recoats92616643recoats
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recombs1336753recombs
recons84922993reco_ns
recooks134711233recooks
records105213923records
recorks134813023recorks
recoups1188843recoups
recrowns13246143recrowns
redacts10510943redacts
redan66125013red__an
redans75421023red_ans
redates83423863redates
redbay1238333red_bay
redbays1336013redbays
redbones1137593redbones
redbuds11144283redbuds
redbugs11134463redbugs
redcap1158493red_cap
redcaps1247073redcaps
redcoat10410883redcoat
redcoats1147123redcoats
reddens9259783reddens
redders93615343redders
reddles93315773reddles
redds74617833red__ds
redear73515173red_ear
redears82814453redears
redeems1037163redeems
redes65139123red__es
redeyes112910973redeyes
redfins1139923redfins
redhead1257053redhead
redheads1336173redheads
redia65524483red_ia_
rediae74221993red_iae
redial74923113red_ial
redials84416883redials
redips93713843red_ips
redlegs936823redlegs
redness82012443redness
redo56029363redo___
redock134311543redo_ck
redoing93516733redoing
redon65424883redo__n
redone74820053redo_ne
redoubt10167843redoubt
redoubts11153973redoubts
redound968173redound
redounds1055963redounds
redout71820253redo_ut
redox134714233redo__x
redpolls1144013redpolls
redraw10269853red_raw
redrawn11245953redrawn
redream10107913redream
redreams1195953redreams
redress82511873redress
redries83721713redries
redroots937753redroots
reds56042863red___s
redtops1037373redtops
redubs9358383red_ubs
reduces10513343reduces
redware1139353red_ware
redwares1239053red_wares
redwood1236513redwood
redwoods1345773redwoods
redyes104214083red_yes
reendows12234683reendow_s
reflows13258983reflow_s
refocus1236973refocus
refolds11298953refolds
reforms1239813reforms
reginas85614063reginas
reglows11288843reglow_s
regrows11269153regrow_s
rejoins143111383rejoins
reload7413893relo_ad
reloads8911313reloads
reloan6415693relo_an
reloans7313133reloans
relocks134411293relocks
relooks114010723relooks
remolds10299703remolds
remora8414583remora_
remotes94521613remotes
removal1236733removal
removals1345643removals
removes124514713removes
remudas1035833remudas
renewal1038703renewal
renewals1137273renewals
renews93811753renew_s
renown9369983renow_n
reoils64516873re_oils
replows12329703replow_s
repolls939053repolls
reports94916213reports
repos74725793repo__s
reposal939113reposal
reposals1037403reposals
reposes94021263reposes
repots85621003repo_ts
repours9310223repours
repower12329883repower
repowers13288533repowers
rerolls739943rerolls
reroofs1037943reroofs
resaws93713513resaw_s
resedas839123resedas
resews94814173resew_s
reshows132510453reshow_s
resoak10311093reso_ak
resoaks1148973resoaks
resods74116303reso_ds
resoles73823653resoles
resorbs95010523resorbs
resorts74817193resorts
resow88217243resow__
resowed113712253resowed
resown94112923resow_n
retinas74819353retinas
retools73411023retools
retorts76016513retorts
retotal739843retotal
retotals838463retotals
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
rewan85623663re__wan
rewash1237673re__wash
rewax155713923re__wax
rewords115413973rewords
reworks145113593reworks
rezones163213943rezones
rhodoras1244453rhodoras
riojas1335813r_iojas
rotas54827723r__otas
rowan85418733r__owan
rowans95715343r__owans
rows75941753r__ow_s
rubdowns1473073rubdowns
rugolas836373rugolas
rugosas844973rugosas
rundowns1284523rundowns
senoras72714953senoras
serosas7312663serosas
serows96016393serow_s
uredos73910623uredo__s
widows1376563widow_s

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340272196.87319500.5
3Display Results2192190.0762881.6
 (SQL Overall)1786912197.10925135.9
 
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.