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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
chalazas224589(None) 
chalaza2145731chalaza_
chalazae2244421chalazae
chalazal2243871chalazal
chalahs15289882chala_hs
chalazia2245132chalazia
challas124414122chal_las
chalupas1554382chalupas
halalas104214082_halalas
achalasias1553843achalasias
atalayas1144783atalayas
balatas9311833_balatas
cabalas113516003c_abalas
cabanas112413033c_abanas
calabash1544253c_alabash
calabazas2243083calabazas
calamar1149293c_alamar
calamars1238133c_alamars
calamus1139243c_alamus
calesas9411833c_alesas
callas84526753c_al_las
casabas1139983c_asabas
casavas1237823c_asavas
chachkas22173733chachkas
chacmas1638003cha_cmas
chadars1338293chada_rs
chakras16428503cha_kras
chalah143511663chal__ah
chalazion23113723chalazion
chalazions24113323chalazions
chalcids1635893chalcids
chalehs15268803chal_ehs
chalets122813473chal_ets
chalices15310813chalices
chalks155412143chal__ks
challa114014193chal_la_
challah15458323chal_lah
challahs16377563challahs
challies133915643challies
challis124613463chal_lis
chalones13312173chalones
chalupa1444473chalupa_
chamades16138653chamades
chamisas15317813chamisas
champacas2042963champacas
chapatis15127943chapatis
chaplains1645743chaplains
charades141310853charades
charas114223613ch__aras
charases131312763charases
charkas164810963cha_rkas
charkhas20285023charkhas
charlatan1443543charlatan
charlatans1542973charlatans
chazan20269133ch__azan
chazans21268123chaza_ns
chazzan20204853cha_zzan
chazzans21234503chazzans
chelas113817203chel__as
chelates132713843chelates
chlamys1733783ch_lamys
cholas114818003chol__as
cholates132414763cholates
choleras13289043choleras
chollas123811353chol_las
coalas87418963coal__as
colzas174010513c_ol_zas
halachas16317883_halachas
halakah17517963_halakah
halakahs18426633_halakahs
halakhas18386723_halakhas
halala94715093_halala_
halalah13429393_halalah
halalahs14367443_halalahs
halals95018313_hala_ls
halavah16447023_halavah
halavahs17415793_halavahs
halloas104318463_halloas
halmas117017893_hal_mas
halvas124714173_hal_vas
hamadas1339673_hamadas
hamzas20119013_ha_mzas
hawalas13348353_hawalas
khalifas1842513khalifas
palapas11311493_palapas
plazas17409913__plazas
thalamus1343603thalamus

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit146162877.51619446.8
3Display Results87870.0302900.0
 (SQL Overall)178691877.98222386.7
 
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.