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

281 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
haviors134738(None) 
havior1248201havior_
haviours1443841haviours
paviors1237601paviors
saviors1058991saviors
avions94114392_avions
behaviors1772042behaviors
caviars1238622caviars
favors124211402fav_ors
hairs86225172ha_i_rs
harbors12412412harbors
havers124721482hav_ers
haviour1354822haviour
havocs1435652hav_ocs
pavior1138532pavior_
paviours1343612paviours
savior9710172savior_
saviours1154272saviours
savors95616102sav_ors
abhors11410623_abhors
actors81016763_actors
adios65822863_adio_s
advisors12143903advisors
agios65919863_agio_s
airs46447423_a_i_rs
aivers94822323_aivers
algors7312553_algors
amirs75924923_ami_rs
anions64123033_anions
arbors84717883_arbors
ardors74416873_ardors
armors85017813_armors
avers85127313_av_ers
avians93711563_avians
aviary12338413_aviary
aviators11169903_aviators
avion84218343_avio_n
avisos95410483_avisos
avoids104410203_avoids
avos77227013_av_o_s
avows114910983_av_ows
axioms15408053_axioms
axions134713483_axions
bailors93212413bailors
basions94213953basions
behavior1662203behavior_
behaviours1871283behaviours
bevors111610343bev_ors
cahiers123510673cahiers
camions113916133camions
candors104216763candors
cantors94620753cantors
captors113914983captors
carious93320283carious
castors94919443castors
cations94524143cations
cavers115026843cav_ers
caviar11310163caviar_
caviare1238373caviare
caviares1337993caviares
cavicorn1543833cavicorn
cavies114525003cavi_es
cavilers1348113cavilers
cavils114014393cavi_ls
cavings134712543cavings
cavort11316173cav_ort
cavorts1237933cav_orts
chadors1338753cha_dors
chairs114916183cha_i_rs
chantors133710263chantors
chariots1339393chariots
cheviots1643783cheviots
claviers1367103claviers
danios7314603danio_s
davies105020513davi_es
davits104012363davi_ts
devious1138523devious
devisors12347253devisors
devoirs1175783devoirs
divisors12255693divisors
enviers1036993enviers
envious1037223envious
enviros1034913enviros
factors12912123factors
fairs85825443fa_i_rs
fakirs13468083faki_rs
fanions103713073fanions
faqirs18456033faqi_rs
favisms1535443favisms
favor114712453fav_or_
favours13437093favours
flavors1337293flav_ors
gabions102410053gabions
galiots82311323galiots
gators74115833ga_tors
gavials1136603gavials
gavots1038113gav_ots
haars85620473ha__ars
habits113014653habi_ts
habitus12338173habitus
haboobs1495463haboobs
hackers164619043hackers
hadiths1436023hadiths
hadrons113314303hadrons
hafizes2235983hafizes
hafters134614333hafters
haftoros1444173haftoros
hagborn1344953hagborn
hagdons1258523hagdons
haiks125120933ha_i_ks
haikus13538293ha_ikus
hailers104017263hailers
hails85231643ha_i_ls
haints94417583ha_ints
hair76330143ha_i_r_
hairy115316833ha_i_ry
hajis156716283haji__s
hakims1537303haki_ms
halers94926913ha_lers
halides113416663halides
halidoms1485823halidoms
halids104016133hali_ds
halites103221193halites
halitus10339963halitus
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
haloes94623863ha_loes
haloids113012553haloids
halons95720713ha_lons
halos85230253ha_lo_s
halters104619803halters
halvers133311423halvers
hammers144216063hammers
hampers143616953hampers
handers114224333handers
hangars114313493hangars
hangers113120813hangers
hankers144218133hankers
hansoms12238523hansoms
harbor11410723harbor_
harbours1346923harbours
haricots1347333haricots
harlots103413293harlots
harmers124116593harmers
harpers124916203harpers
harriers113712433harriers
harrows132611033harrows
haters94930403ha_ters
hatters104221523hatters
haulers104012443haulers
hauliers1176713hauliers
havens124514043hav_ens
haver115124463hav_er_
haves116034873hav__es
having134220373havi_ng
havoc1337183hav_o_c
hawkers174210333hawkers
hawsers13409483hawsers
hayers124415943ha_yers
hayfork2043763hayfork
hayforks2143423hayforks
hayings14379393hayings
haymows1883813haymows
hazers184615953ha_zers
hazier184712403hazier_
hazings20378343hazings
heavers133717193heav_ers
heavier13429423heavier_
heavies132713873heavi_es
hectors123513263hectors
heirs85618563h_ei_rs
helios94816633helio_s
heriots10312063heriots
heritors11310903heritors
honors94816793h_onors
horrors1078693horrors
hosiers104212643hosiers
hovers124320253hov_ers
humidors1443993humidors
humors11129633h_umors
jailors14328753jailors
janitors1536853janitors
juniors1475783juniors
kafirs13306983kafi_rs
kations114013663kations
labors84016413la_bors
lairs55425873la_i_rs
laveers10329363laveers
lavers94526363lav_ers
leviers103510343leviers
liviers104211073liviers
mahzors2135123mahzors
mairs76228303ma_i_rs
majors154511093ma_jors
maniocs113611443maniocs
manors84420883ma_nors
mavies114923193mavi_es
mavins115119183mavi_ns
mavis105622723mavi__s
mavises122812993mavises
mayors115714193ma_yors
nadirs7109003nadi_rs
nasions73112383nasions
nations74720563nations
navars92810573nav_ars
navies95218623navi_es
obvious1244823obvious
pairs75325833pa_i_rs
pallors9314363pallors
paniers94717333paniers
parlors9312913parlors
pastors94119003pastors
patios85221783patio_s
pavers115021823pav_ers
pavings134011633pavings
pavins114919663pavi_ns
paviour1244623paviour
pavis106422733pavi__s
pavisers13387443pavisers
pavises125315493pavises
pawnors12297203pawnors
payors114312643pa_yors
priors83914483_priors
radios74018673radio_s
rancors9811373rancors
rapiers95012873rapiers
raptors94213353raptors
rations74123433rations
ratios64922673ratio_s
ravers94628183rav_ers
ravines104220233ravines
ravings114614503ravings
ravins94622563ravi_ns
ravioli1055613ravioli
raviolis1146103raviolis
razors154711663ra_zors
revisors11379063revisors
sabirs85414633sabi_rs
sailors73213723sailors
salvors103910913salvors
sanious7514103sanious
sapors84118813sa_pors
sartors7314963sartors
savers93825923sav_ers
savines104417633savines
savings114412953savings
savins93923133savi_ns
saviour1035213saviour
savor85417943sav_or_
savory124310563sav_ory
savours10389343savours
savoys12427893sav_oys
seniors73413613seniors
shavers134115093shav_ers
shavies134213203shavi_es
shavings15356333shavings
tabors84517113ta_bors
tailors73212393tailors
talions7314113talions
tapirs84113173tapi_rs
vairs85019133va_i_rs
valors93413773va_lors
vapors113812693va_pors
variers103712663variers
various103113103various
vavasors14153653vavasors
viers85621953__viers
vigors102911483__vigors
viols86118103__viols
visors92912223__visors
vizors18328903__vizors
wairs86424063wa_i_rs
waivers133410053waivers
wanions104011373wanions
warriors1135363warriors
wavers125022473wav_ers
wavier124613083wavier_
wavies125019843wavi_es

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.1561145455.1
2DLD Change Limit1340272816.84319586.0
3Display Results2812810.0933021.5
 (SQL Overall)1786912817.09225196.1
 
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.