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

243 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
arbour8421133(None) 
arbor74818111arbo_r
arbours93910041arbours
ardour74110901ardour
armour84411851armour
harbour1247051harbour
about75229082a_bout
amour75014852a_mour
arbors84717882arbors
arboured1156252arboured
ardor64617862ardo_r
ardours8368882ardours
armor75118052armo_r
armours9389852armours
armoury12376232armoury
harbor11410722harbo_r
harbours1346922harbours
labour84210932labour
parlour937262parlour
tabour84011322tabour
tambour1136352tambour
abbot9318453abbo_t
abbots1039283abbots
abhor10411063a_bhor
abjure1536743a_bjure
abler75624313a_bler
abo59045963a_bo__
aboard9312613a_board
abode85518813a_bode
abohm1247973a_bohm
aboil72217543a_boil
aboma91114603a_boma
aboon74918703a_boon
abort76133583a_bort
abos67734413a_bo_s
abound9239863a_bound
above105414323a_bove
abroad9310943abroad
absurd935903a_bsurd
abut66834953a_b_ut
actor71116073acto_r
adjourn1563433adjourn
adnoun757033adnoun
afoul8510193a_foul
airboat9512133airboat
airbound1144123airbound
airbus848343airb_us
album92312653alb_um
algor6513053algo_r
aloud65018073a_loud
ambeer104511603ambeer
amber94523213amb_er
ambler104916453ambler
ambo88225143ambo__
ambos95321253ambo_s
amours83512663a_mours
arb510448423arb___
arbiter939933arbiter
arbored103811603arbored
arbores94016033arbores
arborous1047723arborous
arbs66834733arb__s
arbute8311043arbute
arbutus944843arbutus
archer115016243archer
arco68331543arco__
arcus76918863ar_cus
ardors74416873ardors
arduous837613arduous
arenous7314183arenous
areola6813673areola
areolar779223areolar
areole61017283areole
argol65317263argo_l
argols74514613argols
argon65520593argo_n
argons75018203argons
argosy1036423argosy
argot67728653argo_t
argots74116033argots
argue64818443ar_gue
arguer74510543arguer
argus66716543ar_gus
arider74717743arider
ariose64818723ariose
ariosi64313033ariosi
arioso64312403arioso
arkose104911343arkose
armer76924443ar_mer
armful1167163armful
armoire938133armoire
armorer9259913armorer
armors85017813armors
armory114211473armory
armoured1165223armoured
armourer1054883armourer
armure8710133ar_mure
aroid65428343ar_oid
aroma71220143ar_oma
arose55832083ar_ose
around72712413ar_ound
arouse65019983ar_ouse
arouser74514423ar_ouser
arrear6310253arrear
arroba898663arroba
arrow83414883arro_w
arrows92813483arrows
arrowy12288273arrowy
arroyo936963arroyo
arson55118833arso_n
arsons63917213arsons
artful968273artful
artier63419733artier
arum66129033ar__um
arvo76023433arvo__
arvos86015663arvo_s
auburn836213aub_urn
augur64311213a_ugur
aurous64119263aurous
auteur6107943auteur
awmous1157713awmous
barber104419323barb_er
barbut104617003barb_ut
blur66020533__blur
boar66134293__boar
boor66130683__boor
bourg84113843__bourg
bourn75518483__bourn
bout66353293__bout
bur55744693__b_ur
candour104210243candour
carbo94923843carbo__
carbon104919043carbo_n
carbons115418943carbons
carbora11310703carbora
carbos105122263carbo_s
carboy134914183carbo_y
carboys144711783carboys
caribou1156993caribou_
caribous1258823caribous
carious93320283carious
clour76617283_clour
colour85915093colour
croup95616783cr_oup
cruor7310443cruo_r
darbar959953darb_ar
detour778193detour
devour1076703devour
dolour75710133dolour
dour56330433__dour
drouk1039433dr_ouk
dyvour1393343dyvour
earbud936283earb_ud
erbium1038083erbium
error53712233erro_r
faitour1034883faitour
farceur12525273farceur
faubourg1461693faubourg
favour12438333favour
fervour1343103fervour
flour84916453_flour
four76226863__four
garbler104012563garbler
garboard1247243garboard
garboil1036513garboil
giaour735363giaour
group85413923gr_oup
grout65330423gr_out
harborer1348053harborer
harbors12412413harbors
harboured1544313harboured
haviour1354823haviour
honour94710863honour
hour75827313__hour
humour11116753humour
inpour837063inpour
kronur10415313kronur
labor75117313labo_r
labours9349893labours
larboard1157663larboard
lour45430683__lour
marabou1147493marabou_
marabous1249063marabous
marabout1249103marabout
marbler113511673marbler
odour64710493_odour
orbier839993orbier
our36042893___our
pandour10408213pandour
paramour1246083paramour
parboil1138323parboil
parlor8312673parlo_r
parlours1036153parlours
parlous9414293parlous
parous84024163par_ous
paviour1244623paviour
pour611527473__pour
prior74316173prio_r
prober104516073prober
proud84615483pr_oud
ragout7317183ragout
ramous8417113ramous
rancour987133rancour
razor143012603razo_r
recur74116843_recur
repour8310993repour
rigour7258023rigour
roar46328573_r_oar
roue45941743_r_oue
roup66627693_r_oup
rout46153283_r_out
roux117419363_r_oux
rubout8313563rubout
rumour8127383rumour
sambhur1453083sambhur
sambur10469503samb_ur
santour737373santour
sapour83812373sapour
sarcous9312933sarcous
sartor6313873sarto_r
saviour1035213saviour
savour94110703savour
scour75315533_scour
sour45935893__sour
stour54916743_stour
tabor75518393tabo_r
tabours94110093tabours
tamboura1253893tamboura
tambours1255873tambours
tambur10358713tamb_ur
tenour62610733tenour
tour45530383__tour
trout57332573tr_out
tryout9410753tryout
tumour8137403tumour
valour93010373valour
vapour11378873vapour
various103113103various
velour9328763velour
vigour10256803vigour
vrouw11507343vr_ouw
warbler123211463warbler
your78623433__your

Search took 6 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 Filter1786911127160.186960704.3
2DLD Change Limit1127162435.70319764.3
3Display Results2432430.0633857.1
 (SQL Overall)1786912435.95230022.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.