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

167 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
chitlin1226927(None) 
chitin113114951chit_in
chitling142910661chitling
chitlins13289391chitlins
catlin83819082c_atlin
chili106218482chi_li_
chilis115517872chi_lis
chilli114312772chilli_
chilling143512182chilling
chillis124411602chillis
chitins122713792chit_ins
chitlings15255902chitlings
chiton112612392chit_on
citrin82615412c_itrin
anilin6417793ani_lin
capelin11510973capelin
caplin103216303c_aplin
captain112111063captain
carlin84421823c_arlin
castling11311233castling
catkin123512383c_atkin
catling104819793c_atling
catlins93818843c_atlins
ceili75814793cei_li_
ceiling103416723cei_ling
ceilis85413743cei_lis
certain92612213certain
chablis14368563chablis
chagrin1337893chagrin
chain105723673ch__ain
challie124012853challie
challis124613463challis
chaplain1546193chaplain
charlie123011923charlie
chatelain1445003chatelain
chatting142810143chatting
chichi1637093chichi_
chichis1737073chichis
chicken18278983chicken
chicle134312543chicl_e
chicles143512503chicles
chicly16429203chicl_y
chidden14255223chidden
chiding143911593chi_ding
chieftain1752643chieftain
chiel104918973chiel__
chield124610213chiel_d
chields13507483chields
chiels115115933chiel_s
chiffon1844053chiffon
chignon1344623chignon
chilblain1693193chilblain
child114516223chi_l_d
childe124711213chi_lde
childing15288503childing
chile105626893chi_l_e
chiles115425303chi_les
chiliad1337563chi_liad
chilies124218303chi_lies
chill105619873chi_l_l
chilled133310933chilled
chiller124112183chiller
chillier13328423chillier
chillies134113483chillies
chillily1644113chillily
chills114717703chi_lls
chillum1435443chillum
chilly144113223chi_lly
chiltepin1642893chiltepin
chiming153311833chi_ming
chimla1337593chiml_a
chimlas1437453chimlas
chimley1785163chimley
chin96934743ch___in
chining133316843chi_ning
chinking183210893chinking
chinning14329653chinning
chippie16297693chippie
chipping18389793chipping
chirking18339383chirking
chirming16318643chirming
chirping16278863chirping
chirren12388743chirren
chirring142610173chirring
chiseling1536403chiseling
chit96937463chit___
chital114313883chit_al
chitons122611913chitons
chitosan1374583chitosan
chits105424573chit__s
chitter124112963chitter
chitties13310773chitties
chitty14329433chit_ty
chivying2034973chivying
chlorin123112993chlorin
choline122915383ch_oline
chopin132712183ch_opin
chortling1535563chortling
chuting132910733chut_ing
chytrid1645723chytrid
cilia73016763c_i_lia
cipolin1148783cipolin
citing94220183c_it_ing
citric102812313c_itric
citrine92514023c_itrine
citrins92614363c_itrins
citron83112983c_itron
clitic103315053clit_ic
codlin94516443c_odlin
coiling103723453coi_ling
coition9314313coition
colin76231693c__olin
complin13312073complin
contain9315833contain
cortin82423153cort_in
cretin82917913cret_in
critic103616813crit_ic
cuittling1234103cuittling
curtain9319793curtain
cutin75022783c_ut_in
cutline92914543c_utline
cuttling1138203cuttling
cyclin1339273c_yclin
cymlin1337313c_ymlin
cystein1246053cystein
ghibli1243493ghibli_
ghiblis1353343ghiblis
ghillie11326353ghillie
gittin72910553_gittin
hatpin112610603_hatpin
hili75626633_hi_li_
hilling113821773_hilling
hilting113316893_hilting
hipline12311423_hipline
hitman112710223_hitman
hitmen11239193_hitmen
hitting113017273_hitting
hotline10712343_hotline
hotlink1476753_hotlink
hyalin122210043_hyalin
kitling123313573_kitling
phytin14459003phyt_in
ratlin64116523_ratlin
schilling15286393schilling
shieling123512403shieling
shilling123315383shilling
shitlist1148713shitlist
shittim1245123shittim
shitting123212653shitting
simlin8311733_simlin
theelin1038003theelin
thiamin1236933thiamin
thiazin1945473thiazin
thiolic1247313thiolic
thionin1048663thionin
thirling12248583thirling
titling83715793_titling
violin9311983_violin
whiling143511743whi_ling
whirling15237163whirling
whistling1644733whistling
whiten124111923whit_en
whiting143311303whit_ing
whitlow1642853whitlow
whittling1634383whittling
within123611383_within
witling113215813_witling

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 Filter1786911340270.186960704.3
2DLD Change Limit1340271677.75017293.8
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.99922339.2
 
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.