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

146 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
entailer87783(None) 
entailed989521entailed
entailers976411entailers
detailer9268672detailer
enabler9299362en_abler
entail61114342entail__
entails7912822entail_s
entangler1063962entangler
enticer91510422ent_icer
entoiled968282entoiled
entrainer968582entrainer
nailer64119362_n_ailer
retailer82911572retailer
tailer63823732__tailer
antler64615553ant__ler
antsier7410773antsi_er
assailer844823assailer
attainer8116913attainer
bailer85425253__bailer
bewailer1334863bewailer
centile94217183cent_ile_
centiles103615813cent_iles
centraler1146683centraler
certainer1146193certainer
container11311073container
curtailer1143823curtailer
dentiled1039743dent_iled
detailed10319873detailed
detailers10257253detailers
detainer92910793detainer
eatable91717603eatable_
eatables10169793eatables
emailed10359213e_mailed
empaler11288353empa_ler
enable83318483en_able_
enabled102510633en_abled
enablers10196913en_ablers
enables92813123en_ables
enameler1045883enameler
endanger1045853endanger
engager9278603enga_ger
engrailed1144323engrailed
enhancer1346683enhancer
enjoiner15225653enjoiner
enlarger944153enlarger
ennobler1043543ennobler
enroller867183enroller
ensile62616473en_sile_
ensiled82611433en_siled
ensiles72714833en_siles
entailing1039393entailing
entailment1247653entailment
entangle966253entangle_
entangled1184513entangled
entanglers1163033entanglers
entangles1075563entangles
entases72816273enta_ses
enter54726383ent___er
enterer72015633ent_erer
entice81316863ent_ice_
enticed101411193ent_iced
enticers10139093ent_icers
entices91616333ent_ices
entire61617703ent_ire_
entires71517783ent_ires
entitle7610293entitle_
entitled967503entitled
entitles8710663entitles
entoil6912493entoil__
entoils7810733entoil_s
entrails8310163entrail_s
entrained1089413entrained
entrainers1086963entrainers
entrapper1344853entrapper
entries71523163entri_es
entwine1039143entwine_
entwined1235843entwined
entwines1148753entwines
envier939673en_vi_er
espalier1036363espalier
etoile6312263e_toile_
etoiles7411293e_toiles
eviler94811893e__viler
exiler134712183e__xiler
extoller1564183extoller
fantailed1345563fantailed
frailer10319943_frailer
genteeler1043093genteeler
gentile83515293gent_ile_
gentiles93713523gent_iles
gentler8378953gent__ler
hailer94720343__hailer
inhaler1068053inha_ler
inhauler1163943inhauler
initialer964613initialer
installer945013installer
jailer134316683__jailer
mailer84724183__mailer
nailed74021493_n_ailed
nailers73215893_n_ailers
naiver94311353_n_aiver
nettier74211813netti_er
nettler7349503net_tler
nettlier864813nettlier
obtainer1045793obtainer
penciler1237113pen_ciler
pentacle1239383pentacle_
pentacles1338773pentacles
pintailed1245553pintailed
railer64524933__railer
renailed92512803ren_ailed
rentable101716333rentable_
rentier73618223rent_i_er
retailed94113963retailed
retailers9258773retailers
retailor8285223retailor
retainer82913813retainer
sailer63526103__sailer
snailed83811923sn_ailed
snarler73610633sn_arler
stabler94014933_stabler
staider83912613_staider
stainer73614923_stainer
staler64025823_sta_ler
stapler93913633_stapler
tailed74424663__tailed
tailers73720183__tailers
tailor63412503__tailor
taler56034863__ta_ler
taller63721963__taller
tentacle1037693tentacle_
tentacled1244953tentacled
tentacles1146713tentacles
tentier73815923tent_i_er
tiler56131023__t_iler
toiler63918283__toiler
trailer73015393_trailer
unfairer11184283unfairer
unhailed12219963unhailed
unhairer11174993unhairer
unmailed11229763unmailed
unnailed9229443unnailed
unstabler1145623unstabler
ventail10310453ventail__
ventails1139823ventail_s
wailer93720323__wailer

Search took 8 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 Limit1461621466.57622226.6
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.04525364.2
 
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.