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

75 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
sandpile114677(None) 
sandpiles1246301sandpiles
sandable111612822sandable
sandlike1339712sandlike
sandpiper14103522sandpiper
sandpit1049632sandpi_t
sandpits1146842sandpits
standpipe1443342standpipe
aedile73716653_aed_ile
anile54634463_an__ile
audile73315303_aud_ile
candle94321483cand__le
dandily12279633dand_ily
dandle84218093dand__le
handbill14115163handbill
handily143610873hand_ily
handle104219293hand__le
handlike1639153handlike
handpick2043843handpick
handspike1963223handspike
landfill1253883landfill
landline9311443landline
landside10147443landside
manciple1445093manciple
mandible1337543mandible
mandril1049353mandril_
mandrill1146613mandrill
mandrils1138493mandrils
maniple11249653manip_le
panpipe1034833pan_pipe
pantile93918483pan_tile
ranpike1335933ran_pike
saddle83915493sa_d_dle
sample104215013sa_mp_le
sanative11310473sanative
sandal73317283sand_al_
sandaled1039243sand_aled
sandalled1145903sandalled
sandals82715203sand_als
sandfish1556683sandfish
sandflies1346513sandflies
sandfly1435643sand_fly
sandhi1038193sandhi__
sandhis1139993sandhi_s
sandier84017843sand_ier
sanding93520603sand_ing
sandling102214413sandling
sandpaper14124283sandpaper
sandpeep1342963sandpeep
sandpipers1592853sandpipers
sandshoe1245073sandshoe
sandwich1743653sandwich
sanguine947633sanguine
sanicle91210263san_icle
sanidine939853sanidine
sanitise81511813sanitise
sanitize171410083sanitize
sappily1437163sa_ppily
sardine83317393sard_ine
saxatile1544953saxatile
sedile73517233s_ed_ile
sendable111612043sendable
senile63420213sen__ile
sinopie948783sinopi_e
snappily1544323snappily
spandril1144093spandril_
spandrils1244163spandrils
spile75230083s___pile
standpipes1543073standpipes
sundrily1246063sundrily
tadpole1036143ta_dpole
unpile81914323_un_pile
wandle105316663wand__le
windpipe1643183windpipe
woodpile1444093woodpile

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 Limit146162756.57622226.6
3Display Results75750.0332272.7
 (SQL Overall)178691757.03225411.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.