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 “barny” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

156 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
barny10582173(None) 
barky145721611barky
barmy125218761barmy
barn66444641barn_
barney115314451barney
barns76335141barns
barony115915301barony
carny105822921carny
any68440492_a_ny
army96624182_army
arty77531312_arty
awny105919302_awny
baby116723682ba_by
baddy125016022baddy
badly114918762badly
baffy165511922baffy
baggy125615682baggy
bairn77515532bairn_
bairnly1234502bairnly
bairns86710872bairns
baldy115518932baldy
balky145418242balky
bally105530102bally
balmy125217472balmy
ban58366842ba_n_
band76740912ba_nd
bandy114824182bandy
bane65250432ba_ne
bang74837002ba_ng
bani65334962ba_ni
bank105835752ba_nk
banns75321232banns
bans66555142ba_ns
banty106624002banty
bar58070552bar__
barb85240062bar_b
barbe95328282barbe
barbs95928192barbs
barca91319432barca
bard75648862bar_d
barde85330772barde
bards87139642bards
bare65460522bar_e
bared85144482bared
barely114716792barely
barer74535802barer
bares75457132bares
barf95844412bar_f
barfly14339652barfly
barfs104826002barfs
barge85631022barge
baric96125692baric
baring95135852baring
bark106242152bar_k
barks115735812barks
barley115116762barley
barm86739602bar_m
barms96128462barms
barned95623582barned
barneys12569562barneys
baron78131242baron
barong96015822barong
barons85025382barons
barre75929542barre
bars66564092bar_s
barye105021492barye
bassy1012917102bassy
batty105422242batty
bawdy147513282bawdy
bawty135614102bawty
bay89661642ba__y
benny105217362benny
berry104521772berry
blarney12174762blarney
bonny105816622bonny
bony96732082b_ony
born67338412born_
borne77926792borne
borty105522832borty
brainy114815642brainy
braky145015812braky
bran65740382bran_
brand85124492brand
brandy124712062brandy
brank115222282brank
branny115111832branny
brans75437432brans
brant74742172brant
brawny144710602brawny
braxy175410892braxy
bray95232902b_ray
briny104719662briny
bunny104715802bunny
burly104922832burly
burn65636432burn_
burns74926782burns
burnt75230332burnt
burry105221562burry
bury95633592bur_y
cairny11557822cairny
canny105817692canny
carn66245432carn_
carney115315702carney
carns75937562carns
carry105823782carry
corny106023272corny
darky136018832darky
darn56434622darn_
darns66927892darns
early85324122early
earn46737552earn_
earns55927562earns
fanny114816042fanny
farcy135217092farcy
fawny144711712fawny
ferny115816182ferny
garni6315702garni
hardy125622062hardy
harpy136418212harpy
harry115322952harry
horny115619622horny
karn86129412karn_
karns96624142karns
lardy96119272lardy
larky125218872larky
lawny115912012lawny
many95731862ma_ny
marly106925612marly
marry104821692marry
marvy135014032marvy
nanny84813812nanny
narky126017802narky
nary76931222nar_y
pardy115523952pardy
parry105323752parry
party106630612party
porny106020192porny
rainy85921082rainy
sarky125521782sarky
sharny124711832sharny
tardy94720462tardy
tarn46842722tarn_
tarns56433952tarns
tarry85422512tarry
tarty86328182tarty
tawny114713652tawny
varna84516172varna
vary105226062var_y
wany106432362wa_ny
warn75239322warn_
warns87231002warns
warty119323822warty
wary106740012war_y
yarn75230042yarn_
yarns85621792yarns
zany167316992za_ny

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001561.62333148.5
3Display Results1561560.0334727.3
 (SQL Overall)1786911561.95291542.5
 
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.