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

170 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
warrior104536(None) 
warriors1135361warriors
barrier94017732barrier
barrio8312572barrio_
barrios9310772barrios
carrier93619582carrier
carrion9312672carrion
farrier103514892farrier
harrier104417752harrier
marrier93817522marrier
parrier93717652parrier
tarrier74323172tarrier
warier93722892wa_rier
warring113717972warring
wartier103413912wartier
worrier102311682worrier
aerier64823153_aerier
airier64619363_airier
arbor74818113_a_rbor
ardor64617863_a_rdor
armor75118053_a_rmor
arrear6310253_arrear
arriba867683_arriba
arris56824683_arri_s
arrive91311793_arrive
arriver10117793_arriver
arrow83414883_arr_ow
artier63419733_artier
barkier133814483barkier
barmier114313043barmier
barnier93213673barnier
barrator1048403barrator
barretor1046713barretor
barriers104311883barriers
barring104021593barring
barroom1139373barroom
barrow114512763barr_ow
burrier93613553burrier
cardio9915673cardio_
carried103717153carried
carriers103614203carriers
carries94328013carries
carriole1089863carriole
carrions10312453carrions
carrom10513403carr_om
carrot8423123carr_ot
carryon1237033carryon
charrier1378683charrier
corridor1145033corridor
currier93316703currier
earlier72612743earlier
earring83519013earring
error53712233_err_or
farriers113610743farriers
farriery14295403farriery
farrow12309973farr_ow
firrier103410133firrier
furrier103513663furrier
garring93116713garring
garrison943983garrison
garron73113493garr_on
hairier103111053hairier
harbor11410723ha_rbor
hardier114721543hardier
harried113815533harried
harriers113712433harriers
harries103525493harries
harrow122610773harr_ow
havior1248203ha_vior
horror988723horr_or
hurrier103412943hurrier
jarring153613193jarring
karroo10410013karr_oo
karroos1139313karroos
lardier83518343lardier
larkier113711523larkier
markhor1635463markhor
marlier92614773marlier
marrer83716673marr_er
married104715303married
marriers103312473marriers
marries93825283marries
marring103319553marring
marron83717543marr_on
marrow112812603marr_ow
merrier92612303merrier
mirror848003mirr_or
morrion959003morrion
narrator847563narrator
narrow9269143narr_ow
parador103311413parador
parlor8312673pa_rlor
parried103615723parried
parriers103612903parriers
parries93925843parries
parring103222063parring
parrot8320663parr_ot
partier93520713partier
patriot9314533patriot
pavior1138533pa_vior
prior74316173__prior
quarrier1736843quarrier
sarkier113413313sarkier
sartor6313883sa_rtor
savior9710173sa_vior
scarrier10298453scarrier
sorrier72313733sorrier
sparrier10329143sparrier
starrier8279463starrier
tardier859719993tardier
tarried83914133tarried
tarriers83411713tarriers
tarries73324263tarries
tarring83318303tarring
tarsier74119253tarsier
tartier74123263tartier
terrier73414963terrier
terror63811733terr_or
varier94619353va_rier
wackier16369733wackier
wair75830053wa__i_r
wairing113414313wairing
wanier93920683wa_nier
wanion93213063wa_nion
warbler123211463warbler
warder104020273wa_rder
warding123918143warding
wardroom1445043wardroom
wareroom1346523wareroom
warily122915093wa_rily
waring105029443wa_ring
warison1037083warison
warking153519573warking
warlike142410473warlike
warlord1136293wa_rlord
warmer113816733wa_rmer
warming133515083warming
warmish1538373warmish
warner93717223wa_rner
warning113717093warning
warper114015583wa_rper
warping133715183warping
warrant10614243warrant
warrantor1243213warrantor
warred104019843warr_ed
warren95012853warr_en
warrener1136913warrener
warrens103810893warrens
warrigal1244313warrigal
warsler10289893warsler
warthog1444543warthog
wartime1237743wartime
warwork1757583wa_rwork
warworn1357353wa_rworn
washier133611153washier
waspier12259053waspier
waterier11312083waterier
wavier124613083wa_vier
waxier16439903wa_xier
wearier103613283wearier
wirier94215553w_irier
wordier112511213wordier
wormier12278763wormier
worried11308693worried
worriers11257813worriers
worries104117133worries
worrit92313313worri_t
worrits10258683worrits
wrier84521753w__rier
yarrow12287933yarr_ow

Search took 7 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.406440125.6
2DLD Change Limit1340271705.98322401.3
3Display Results1701700.0632698.4
 (SQL Overall)1786911706.45227695.4
 
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.