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

107 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
chiseler133590(None) 
chiseled1435881chiseled
chiselers1445451chiselers
chiseller1443961chiseller
chiefer1536862chi_efer
chiller124112182chi_ller
chisel112111942chisel__
chiselled1544212chiselled
chisellers1543082chisellers
chisels12219102chisel_s
whistler1496312whistler
achiever1643843achi_ever
canceler12238913canceler
ceiler84013963cei__ler
chandler14358373chandler
channeler1444603channeler
chaser114918383chas__er
chastener1445703chastener
chaster124718503chas_ter
cheder125113493ch__eder
cheeper143610743ch_eeper
cheer105420383ch__e_er
cheerer123511753ch_eerer
cheesier1335963cheesier
chestier1387423chestier
chewer145512613ch__ewer
chicaner1586073chicaner
chicer134513603chi__cer
chichier1836023chichier
chicle134312543chi_cle_
chicles143512503chi_cles
chider125116053chi__der
chiel104918973chi_el__
chield124610213chi_el_d
chields13507483chi_elds
chiels115115933chi_el_s
chigger1436003chi_gger
childlier1543093childlier
chile105626893chi__le_
chiles115425303chi__les
chilled133310933chi_lled
chillers133710923chi_llers
chillier13328423chillier
chimbley2063133chimbley
chimer135517203chi__mer
chimere144010633chimere_
chimeres153511313chimeres
chimley1785163chi_mley
chinkier17377363chinkier
chipper163912583chi_pper
chippier17297673chippier
chirker16429323chi_rker
chirper14359963chi_rper
chirpier15276303chirpier
chiseling1536403chiseling
chitter124112963chi_tter
choler113717153ch__oler
chortler13336843chortler
chuckler1935553chuckler
circler1136423c_ircler
coiler84421593coi__ler
consoler102812613consoler
corselet10414573corselet
crippler14826713crippler
crisper113511053cris_per
crispier12297253crispier
crueler939023c_rueler
cudgeler1253313cudgeler
cupeler1177483c_upeler
curseder1145343curseder
driveler1284693driveler
epistler1044833epistler
heeler93917313_h_eeler
higgler12369803_higgler
hiller94421633_hi_ller
hirseled12106253_hirseled
hisser94713793_his_ser
hissier103410503_hissier
hosteler1137273_hosteler
hostler103411023_hostler
hustler103410753_hustler
libeler9219003_libeler
schiller13296473schi_ller
shielder1235183shi_elder
shingler12268633shingler
shiverer14186663shiverer
shoveler14165583shoveler
sniveler1155253sniveler
spieler93111233spi_eler
teaseler8176573teaseler
thistle10107803thistle_
thistles1198233thistles
thistlier1243653thistlier
wheeler13298773wh_eeler
whiffler2033483whiffler
whirler13307603whi_rler
whisker17367933whis_ker
whisper15298013whis_per
whisperer17133693whisperer
whistle13107533whistle_
whistled1595783whistled
whistlers1595163whistlers
whistles14108213whistles
whitener1435733whitener
whittler1495193whittler
whosever1742893whosever
wiselier1137363_wiselier

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.423422437.4
2DLD Change Limit1461621077.65319098.7
3Display Results1071070.0502140.0
 (SQL Overall)1786911078.12621990.0
 
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.