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

83 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
pigtails114603(None) 
pigtail1046611pigtail_
pintails10310161pintails
hightails1645302hightails
pigtailed1353492pigtailed
pintail9311172pintail_
pistils93314302pist_ils
ringtails1044432ringtails
sprigtails1382782sprigtails
wagtails1244442wagtails
abigails1143323abig_ails
agnails837003_agnails
airmails1045263airmails
bangtails1243593bangtails
bobtails1245193bobtails
cattails1038553cattails
curtails10318243curtails
details84214043_details
digitalis1144953digitalis
digitals1045433digita_ls
distains9413603distains
distils83015803dist_ils
engrails945383engrails
entails7912823_entails
fantails1139693fantails
fishtails1543663fishtails
foxtails1844583foxtails
grails77518783__grails
hightail1545253hightail_
lugsails942743lugsails
nitrils72810703ni_trils
oxtails1436383_oxtails
pails75833063p___ails
partials101911953partials
pastils94416173past_ils
pertains102113413pertains
petals84719813p_eta_ls
pibals103813083pi_ba_ls
pickadils1842283pickadils
pietas84516503pieta__s
pieties9419223piet_ies
piggies113813483pig_gies
piggins113010473pig_gins
pigmies122610993pig_mies
pignolis1146053pignolis
pigskins1544253pigskins
pigsties1139783pigsties
pinballs1246933pinballs
pineals93212843pinea_ls
pintadas11105063pintadas
pintados11105993pintados
pintailed1245553pintailed
pintanos10107553pintanos
pintas85021393pinta__s
pipals104213643pi_pa_ls
pistil83915073pist_il_
pistols93213983pist_ols
pitas77427673pi_ta__s
pitayas1286263pi_tayas
pitfalls1345373pitfalls
pithily1567033pi_thily
pities83828083pi_t_ies
pittas86014523pitta__s
pontils9312213pont_ils
ponytails1443653ponytails
portals94015563porta_ls
postals93716373posta_ls
prevails1337663prevails
rattails837133rattails
redtails968003redtails
retails74718973_retails
ringtail944693ringtail_
sigils73912363sig__ils
signals8359163signa_ls
spitals93011593spi_ta_ls
sprigtail12122773sprigtail_
springtails14112223springtails
tails55634193___tails
ventails1139823ventails
vigils104210193vig__ils
vitals94514303vi_ta_ls
wagtail1145043wagtail_
whiptails1742903whiptails

Search took 9 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.1731032896.0
2DLD Change Limit146162838.08018089.4
3Display Results83830.0302766.7
 (SQL Overall)178691838.28321573.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.