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

148 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
abalone93890(None) 
abalones1038751abalones
alone55732962__alone
amarone9311202amarone
baloney1237482_baloney
chalone12312102chalone
zabaione1942792zabaione
zabajone2642052zabajone
abandon1045463abandon_
abandoned1342723abandoned
abandoner1242693abandoner
abandons1145353abandons
abase76023483aba__se
abasing10610673abasing
abate76627843aba__te
abating10413973abating
abator84512723abato_r
abators94413093abators
abaxile1644083abaxile
abele76323253abel__e
ablate82219213ab_late
ablaze17239833ab_laze
able66340533ab_l__e
ablins8316193ab_lins
abloom1039783ab_loom
abode85518813ab__ode
abollae936943abollae
aboon74918703ab_oon_
above105414323ab__ove
abscond1244503abscond
absolve1244513absolve
acarine9316003acarine
acauline1046903acauline
acaulose1044383acaulose
acetone9310793acetone
agarose838673agarose
agelong934983agelong
agone65924553__agone
airline7315033airline
alamode1038163alamode
alane56135613__alane
alanine7316863alanine
albacore1243553albacore
aline57243153__aline
alkaline12168283alkaline
allonge837023a_llonge
aloe45540193__alo_e
along65419493__along
amarones10311353amarones
amazon1736833amazon_
amazons1836653amazons
amidone10349313amidone
amylene12106883amylene
amylose1237193amylose
anagoge9166643anagoge
analog7159973analo_g
analogs82810453analogs
analogue9136253analogue
analogy11177853analogy
analyse10208893analyse
analyte10158813analyte
analyze19167013analyze
ancone83916953a_ncone
anemone9119453anemone
aniline7418473aniline
anyone94612733a_nyone
apagoge11164683apagoge
apolune945283apolune
aquatone1744913aquatone
aslope839013a_slope
atone56527983__atone
axone125918473__axone
azlon144312873a_zlon_
azlons154110423a_zlons
bacon95620593_bacon_
bacons104917583_bacons
balance11510263_balance
balcony1435853_balcony
bale66353843_bal__e
baleen8613053_baleen
baling94829693_baling
ballon84117493ballon_
ballonet10314503ballonet
ballonne1045243ballonne
ballons93916963ballons
baloneys1334663_baloneys
bane65250433_ba__ne
baron78131243_baron_
baronet91022213_baronet
barong96015823_barong
baronne938273_baronne
barons85025383_barons
barony115915303_barony
baton75822423_baton_
batons85519423_batons
bayonet121212213_bayonet
begone9512133_begone
belon73924113_belon_
belong93411043_belong
belons84119413_belons
bizone1738603_bizone
bloke114316633_b_loke
blond85618373_b_lond
blonde94813293_b_londe
boloney1247763_boloney
bone65949323_b__one
bubaline1247163bubaline
bygone1256173_bygone
byline11311643_byline
cabezone2144433cabezone
calzone1848623_calzone
chalones13312173chalones
clone75728163__clone
colone85425003_colone
cyclone1437243cyclone
etalon648973etalon_
etalons739073etalons
flavone1335523flavone
galore73514873_galore
halazone2046113halazone
halon86124863_halon_
halons95720713_halons
hyaline132310723hyaline
kalong1177703_kalong
lone45849133___lone
maline84529093_maline
oblong935383ob_long
opaline9412483opaline
pantalone1146833pantalone
praline93019743praline
sabaton937713sabaton_
sabatons1037843sabatons
sabayon1244233sabayon_
sabayons1343963sabayons
sabulose1044613sabulose
saline65132703_saline
salon55228553_salon_
salons63823693_salons
scalene9310773scalene
tagalong1042763tagalong
talon55824113_talon_
taloned8310223_taloned
talons64019443_talons
valine94623093_valine
violone1037153violone
zabaglione225753zabaglione
zabaiones2043003zabaiones
zabajones2742003zabajones

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.436409841.7
2DLD Change Limit1340271486.75019855.9
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.