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

143 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
chiliad133756(None) 
chiliads1445851chiliads
child114516222chil__d
chili106218482chili__
chiliadal1552182chiliadal
chiliadic1742992chiliadic
chiliasm15134512chiliasm
chiliast13117932chiliast
chilies124218302chilies
chilis115517872chili_s
chilled133310932chilled
chivied16368382chivied
cilia73016762c_ilia_
iliad64613452__iliad
acholia1239973acholia_
acholias1349573acholias
carload1039783carload
ceiled94114953ceil_ed
ceili75814793ceili__
ceilidh1345363ceilidh
ceiling103416723ceiling
ceilis85413743ceili_s
celiac101910433c_eliac
chad105525503ch___ad
chalah143511653chal_ah
chalcid1537873chalcid
chalice14311043chalice
chaliced1637043chaliced
chalked17449863chalked
challa114014193challa_
challah15458323challah
challas124414123challas
chela103916803chel_a_
chelae113614603chel_ae
chelas113817203chel_as
cheliped1635043cheliped
cheloid13310823cheloid
chevied16357483chevied
chia96026623ch__ia_
chiao105618363ch__iao
chias104625513ch__ias
chica125818263chi_ca_
chicas135916463chi_cas
chid106626403ch__i_d
chided135113963chi_ded
chiding143911593chiding
chield124610213chi_eld
childbed1742883childbed
childe124711213chil_de
childes134211273childes
childing15288503childing
childish1744393childish
childly1644803childly
chile105626893chil__e
chiles115425303chil_es
chiliarch1952463chiliarch
chiliasms1693493chiliasms
chiliasts14134343chiliasts
chilidog15132903chilidog
chill105619873chil__l
chiller124112183chiller
chilli114312773chil_li
chillier13328423chillier
chillies134113473chillies
chillily1644113chillily
chilling143512183chilling
chillis124411603chillis
chills114717703chil_ls
chillum1435443chillum
chilly144113223chil_ly
chilopod1694653chilopod
chimar133911463chi_mar
chimed145814833chi_med
chiming153311833chiming
chimla1337593chimla_
chimlas1437453chimlas
china105022473chi_na_
chinas115119383chi_nas
chined125620063chi_ned
chining133316843chining
chinked174011023chinked
chinned134810493chinned
chinwag1643533chinwag
chipped174110813chipped
chiral114614413chi_ral
chirked173810333chirked
chirmed15379733chirmed
chirped15379783chirped
chirred133612123chirred
chital114313883chi_tal
chitin113114953chiti_n
chitins122713793chitins
chitlin12269273chitli_n
chitling142910663chitling
chitlins13289393chitlins
chivies153412853chivies
chivvied2052523chivvied
chola104718033chol_a_
cholas114817993chol_as
choline122915383choline
cholla113911023cholla_
chollas123811353chollas
chorial124214143chorial
ciliary1247923c_iliary
ciliate9514593c_iliate
ciliated11510943c_iliated
cilice103213353c_ilice
cilium104311373c_ilium
citied94014143c_itied
civilian1344453civilian
clad76225823c__l_ad
clivia1177233clivia_
clivias1266693clivias
coeliac1138233coeliac
coiled95123933coil_ed
coiling103723453coiling
colead94114643c_olead
collied103316673collied
cullied104012353cullied
exilian1446963exilian
filial93013253_filial
halid94424973_hali_d
heliac111010893_heliac
helipad1344723_helipad
hila76228353_hil_a_
hilar85418143_hil_ar
hili75626633_hili__
hilled104022223_hilled
hilted104016043_hilted
ilia46026813__ilia_
iliac75013483__iliac
iliads7448673__iliads
ilial55317833__ilial
lilied73913213_lilied
milia72719563_milia_
scholia1237823scholia_
shilled113313623shilled
shipload1464343shipload
shitload1294003shitload
thulia936113thulia_
thulias1035743thulias
whiled134514133whil_ed
whiling143511743whiling

Search took 7 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 Limit1340271436.12621878.4
3Display Results1431430.0433325.6
 (SQL Overall)1786911436.32528251.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.