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 “pinguid” 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
pinguid114624(None) 
languid936622languid
penguin1045872penguin
pinged104321382ping_ed
pongid104111582pong_id
binged105920823bing_ed
cingula10327173cingula
dinged95221783ding_ed
dingus83611843dingu_s
fungoid1245253fungoid
guid66022823___guid
hinged114618923hing_ed
indued83411653_indued
ingulf10310353_ingulf
inlaid7310143_inlaid
intuit6314083_intuit
jingled164111063jingled
kingbird1663033kingbird
kinged124215293king_ed
kingpin1445003kingpin
kingside1444263kingside
lingcod1143683lingcod
lingua7509913lingu_a
linguae8398413linguae
lingual8379083lingual
linguica1143483linguica
linguine937593linguine
linguini945533linguini
linguisa944473linguisa
linguist948573linguist
lingula8428803lingula
liquid1637143li_quid
mingled113612733mingled
misguide12145703misguide
pagurid11105443p_agurid
panged104722333pang_ed
penguins1145383penguins
pidgin10259813pidg_in
pigged114214153pi_gged
piggie103210773pi_ggie
piggin103111093pi_ggin
pignus937953pignu_s
pignut9311573pignu_t
pignuts1035613pignuts
pilgrim1244643pilgrim
pinched153812453pinched
pined85935323pin__ed
pinfold1336233pinfold
ping75943593ping___
pinger94324093ping_er
pingers104020743pingers
pinging113419553pinging
pingo87122713ping__o
pingoes105116523pingoes
pingos95317673ping_os
pings85830883ping__s
pinhead13347073pinhead
pinked134819883pin_ked
pinkie124414273pin_kie
pinned94818383pin_ned
pinnula934913pinnula
pinnule936003pinnule
pintail9311183pintail
pinup9612883pin_u_p
pinups1037413pin_ups
pinweed1346933pinweed
pinyin112710613pin_yin
piqued1836213pi_qued
plagued11307473plagued
ponged105619353pong_ed
pongids11347413pong_ids
preguide1255423preguide
pungled114210083pungled
rigid7913893ri_g_id
ringed84623843ring_ed
ringgit946013ringgit
ringside1045403ringside
singed85422293sing_ed
singled93914683singled
sphingid1543743sphing_id
tineid74412023tin_eid
tinged84220803ting_ed
tingled93712803tingled
tongued946323tongued
unguis738453_unguis
winged114620833wing_ed
wingtip1343613wingtip
zincoid1946663zincoid
zinged174414623zing_ed

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 Limit134027896.56320421.6
3Display Results89890.0332697.0
 (SQL Overall)178691897.00225520.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.