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

65 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
pushpin144323(None) 
pushpins1543341pushpins
bushpig1542572bushpig
pushing133615452push_ing
arshin9312173arsh_in
bushing134018583bush_ing
bushman1455693bushman
bushmen1436303bushmen
bushpigs1642153bushpigs
bushtit1245963bushtit
buskin123811493bus_kin
cushion1236403cushion
cuspid11429213cus_pid
cuspis105010703cus_pis
dishpan13105523dishpan
duckpin1643463duckpin
dustbin1044543dustbin
dustpan1043243dustpan
fuchsin15124373fuchsin
fusain958643fus_ain
gushing124014223gush_ing
hushing144514473hush_ing
lupin75215843lu__pin
lushing114316113lush_ing
mushing134217633mush_ing
muslin8312213mus_lin
pashing135120513pash_ing
pashmina1543313pashmina
phosphin1865543phosphin
pippin92810303p_ippin
pishing134314373pish_ing
postin83521033pos_tin
puffin141149003pu_ffin
pulping123612323pu_lping
pulpit10310933pu_lpit
pumping144213553pu_mping
pumpkin1743523pumpkin
punkin123611523pu_nkin
pupil94712983pu__pil
pupping114412503pu_pping
purin75527593pu__rin
purlin83615863pu_rlin
purloin9107493purloin
push95526623push___
pushdown1742523pushdown
pushed125017463push_ed
pusher114318283push_er
pushers123814503pushers
pushes114621663push_es
pushful1544493pushful
pushier123611093pushier
pushily15247983pushily
pushrod1343703pushrod
pushup1335273push_up
pushups1433653pushups
pushy134614353push__y
rushing113817703rush_ing
shin75634313__sh_in
spin66231303__s_pin
sushi8310493sush_i_
sushis9311183sush_is
sustain738773sustain
tushie939723tush_ie
tushing114214013tush_ing
unpin72613243_u_npin

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.403443402.0
2DLD Change Limit134027656.56320421.6
3Display Results65650.0164062.5
 (SQL Overall)178691656.98225593.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.