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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
penguin104587(None) 
penguins1145381penguins
pinguid1146242pinguid
anguine839913_anguine
bedouin1046043bedouin
beduin939713be_duin
begin85117353be_g_in
beguine1068503be_guine
begun85113443be_gu_n
benzin1738933ben_zin
benzoin1846263benzoin
dengue838253dengu_e
dengues938183dengues
dentin73919573den_tin
endrin7312403_endrin
enduing9249723_enduing
engine71114863_eng_ine
engrain838353_engrain
engulf1038883_engulf
enjoin1357833_enjoin
ennui537523_ennui_
ennuis636473_ennuis
ensuing8239543_ensuing
genuine838373gen_uine
henequin2042823henequin
kingpin1445003kingpin
languid936623languid
leaguing1035343leaguing
leggin8268593le_ggin
legumin1045073le_gumin
linguine937593linguine
linguini945533linguini
pangen94115923pang_en
panging113319113pang_ing
pangolin1147773pangolin
pectin102615533pe_ctin
pegging122811133pe_gging
pein65834943pe___in
pekin111514423pe__kin
pencil103712973pen_cil
pending114119773pen_ding
pengo84317593peng__o
pengos94612413peng_os
penicil1138833penicil
penis75129323pen__is
penman10312323pen_man
penmen10311493pen_men
penni74617903pen_ni_
pennia84412973pen_nia
pennine93712953pen_nine
penning103616493pen_ning
pennis84315743pen_nis
pennon8310643pen_non
penpoint1249453penpoint
pensil83013333pen_sil
pension9412203pension
penult8314653pen_ult
penury1148103pen_ury
pepsin10310853pe_psin
peregrin1146993peregrin
pertain92714963pertain
phenazin2245603phenazin
pidgin10259813pidg_in
piggin103111093p_iggin
pinging113419553ping_ing
pinyin112710613pin_yin
plaguing1236033plaguing
pongid104111583pong_id
ponging113416153pong_ing
popgun1145733popgu_n
progun968783progu_n
pungling12228663pungling
punkin123611523pun_kin
reagin74915533reag_in
regain74517763re_gain
renin54830033ren__in
rennin63914033ren_nin
requin15310713re_quin
sanguine947633sanguine
sengi64016513seng_i_
sequin1538523se_quin
spongin1036373spong_in
tenpin8310583ten_pin
tenuis64213083ten_uis
tonguing1046263tonguing
unguis738453_unguis
venging123710943veng_ing
venin85118663ven__in
wangun1037113wangu_n

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 Filter1786911340270.406440125.6
2DLD Change Limit134027897.18618651.1
3Display Results89890.0302966.7
 (SQL Overall)178691897.62223444.1
 
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.