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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
entertained124517(None) 
entertainer1154481entertainer
entertain947862entertain__
entertainers1253662entertainers
entertains1047622entertain_s
entrained1089412ent_r_ained
intertwined1544592intertwined
appertained1653523appertained
ascertained1452293ascertained
engrained1145493en_gr_ained
entertaining1354383entertaining
entertainment1563053entertainment
entrainer968583ent_r_ainer
extermined2045323exter_mined
interjoined1944943interjoined
interlined111211263inter_lined
intertwine1347613intertwine_
intertwines1446643intertwines
pertained1238503__pertained
uncurtained1452983uncurtained
untrained10510993unt_r_ained
attained997354_at__tained
centerline1247044center_line_
centerlines1346994center_lines
certainer1146194__certainer
counterstained1754844counterstained
curtained1265504__curtained
destained1158254__destained
detained103111644__de_tained
determined1455824deter_mined
detrained1158914det_r_ained
enchained1545494en__chained
energised1145184en_er_gised
energized2044544en_er_gized
enervated1347314en_erva_ted
engrailed1144324en_gr_ailed
enshrined1344524enshr__ined
entailed989524en___tailed
enterable11312644enter_able_
entered82718884enter____ed
entering91920054enter__in_g
enteritides1245844enteritides
enteritises1147724enteritises
enterprise1255544enterprise_
enterpriser1363764enterpriser
enterprises1355544enterprises
entertainments1672454entertainments
enthralled1443694enthr_alled
enthroned1396884enthr__oned
entrain7313074ent_r_ain__
entrainers1086964ent_r_ainers
entrains8312964ent_r_ain_s
entranced1247394ent_r_anced
entrapped1484874ent_r_apped
entreated10310974ent_rea_ted
entreaties1048114entreati_es
entreating11811554entreatin_g
entwined1235844en___twined
esterified1445404esterifi_ed
eternalized21117334e_ternalized
eternised10116274e_ter_nised
eternized19116604e_ter_nized
expertized2944714expert_ized
extermine1848284exter_mine_
extermines1947784exter_mines
externalised2054124externalised
externalized2955194externalized
ingrained1145384in_gr_ained
interacted13411214inter_acted
interfaced1647944interfa_ced
interfiled1447654inter_filed
interlaced1349234interla_ced
interlaid1049354interlai__d
interlapped1644094interlapped
interlarded1345234interlarded
interline91218014inter_line_
interliner101311154inter_liner
interlines101116454inter_lines
interlinked1644844inter_linked
intermatted1476304intermatted
intermixed2046104inter_mixed
internalised13127044internalised
internalized22147454internalized
interned93016654inter___ned
intertie8317614intert_i_e_
interties9320334intert_i_es
intertilled1245814intertilled
intertwisted16113064intertwisted
intervened14109064inter_vened
intestine9411854intest_ine_
intestines10410254intest_ines
nemertine1147074nemert_ine_
nemertines1245964nemert_ines
overentertained1972044overentertained
overtrained1547104_overtrained
pretrained1357064pretr_ained
reattained1144584reat__tained
restrained1148414rest_r_ained
retained93016094__re_tained
retrained10411314ret_r_ained
strained9412254_st_r_ained
tearstained1251924__tearstained
trained84117204__t_r_ained
uncertain1146204uncertain__
uncertainly1653224uncertainly
uncertainty1652854uncertainty
underlined121610214under_lined
undermanned1544184undermanned
undermined14189134under_mined
undertaxed1946514underta_xed
undrained1138524un_dr_ained
unrestrained1353284unrestrained
unstained1038684un__stained
unstrained1146374unstr_ained

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191148.37617767.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.85820172.8
 
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.