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

117 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
warriors113536(None) 
warrior1045361warrior_
barriers104311892barriers
barrios9310772barrio_s
carriers103614202carriers
carrions10312452carrions
farriers113610742farriers
harriers113712432harriers
marriers103312472marriers
parriers103612902parriers
tarriers83411712tarriers
worriers11257812worriers
arbors84717883_a_rbors
ardors74416873_a_rdors
armors85017813_a_rmors
arrears738843_arrears
arris56824683_arri__s
arrises71617583_arrises
arrivers11137003_arrivers
arrives101311513_arrives
arrows92813493_arr_ows
barrators1148393barrators
barretors1146243barretors
barrier94017753barrier_
barrio8312583barrio__
barrooms1237903barrooms
barrows123411693barr_ows
carious93320283ca_rious
carrier93619583carrier_
carries94328013carri_es
carriole1089863carriole
carrioles1169473carrioles
carrion9312673carrio_n
carroms11512403carr_oms
carrots9714623carr_ots
carryons1337103carryons
corridors1245083corridors
curriers103410753curriers
earrings9299633earrings
errors63311313_err_ors
farrier103514893farrier_
farriery14295403farriery
farrows13259793farr_ows
furriers11369493furriers
garrisons1043793garrisons
garrons82713463garr_ons
harbors12412413ha_rbors
harrier104417763harrier_
harries103525503harri_es
harrows132611043harr_ows
haviors1347383ha_viors
horrors1078693horr_ors
hurriers11358893hurriers
karroos1139313karr_oos
markhors1745393markhors
marrers93414313marr_ers
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marri_es
marrons93216973marr_ons
marrows122911833marr_ows
mirrors938623mirr_ors
morrions1077673morrions
narrators947863narrators
narrows10258853narr_ows
paradors113411903paradors
parlors9312913pa_rlors
parrier93717653parrier_
parries93925843parri_es
parrots9312743parr_ots
partiers103514243partiers
patriots1038053patriots
paviors1237603pa_viors
priors83914483__priors
quarriers1845183quarriers
sartors7314973sa_rtors
saviors1058993sa_viors
tarrier74323173tarrier_
tarries73324263tarri_es
tarsiers8298533tarsiers
terriers84210823terriers
terrors73112213terr_ors
variers103712663va_riers
various103113103va_rious
wairs86424063wa__i_rs
wanions104011373wa_nions
warblers13319103warblers
warders113416813wa_rders
wardrooms1544183wardrooms
warerooms1445823warerooms
warhorse1445353wa_rhorse
warier93722893wa_rier_
warisons1136903warisons
warlord1136293wa_rlord
warlords1245303wa_rlords
warmers124514293wa_rmers
warners103315563wa_rners
warnings12358453warnings
warpers123413583wa_rpers
warrantors1343043warrantors
warrants1168503warrants
warreners1236203warreners
warrens103810893warr_ens
warrigal1244313warrigal
warrigals1343783warrigals
warring113717973warri_ng
warslers11328073warslers
warthogs1544833warthogs
wartier103413913wartier_
wartimes1336963wartimes
warwork1757583wa_rwork
warworks1877063wa_rworks
warworn1357353wa_rworn
worrier102311683worrier_
worries104117133worri_es
worrits10258683worri_ts
yarrows13277863yarr_ows

Search took 9 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.483369960.7
2DLD Change Limit1461621178.00018270.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.52920951.0
 
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.