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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

169 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
pintails1031016(None) 
pigtails1146031pigtails
pintail9311181pintail_
entails7912822_entails
fantails1139692fantails
pigtail1046622pigtail_
pinballs1246932pinballs
pineals93212852pinea_ls
pintadas11105082pintadas
pintados11105992pintados
pintailed1245552pintailed
pintanos10107552pintanos
pintas85021392pinta__s
pistils93314302pist_ils
pontils9312212pont_ils
ponytails1443652ponytails
ringtails1044442ringtails
ventails1139822ventails
agnails837003agn_ails
airmails1045273airmails
aventails1244993aventails
bangtails1243593bangtails
bobtails1245193bobtails
brantails1146313brantails
cantals93919573canta_ls
cattails1038553cattails
centals94317053centa_ls
contains10316533contains
contrails11410543contrails
curtails10318243curtails
dentals83915393denta_ls
dentils84115583dent_ils
details84214043_details
disentails1147013disentails
distains9413603distains
distils83015803dist_ils
entail61114343_entail_
entoils7810733_entoils
entrails8310163_entrails
fantail10310233fantail_
finalis103313663fin_alis
finals94316163fin_a_ls
finials103210153finia_ls
fishtails1543663fishtails
foxtails1844583foxtails
gingalls1096433gingalls
gingals9109313ginga_ls
hightails1645313hightails
horntails12124823horntails
infalls1038943_infalls
inhauls1035523_inhauls
initials848103_initials
installs858923_installs
instals7611713_insta_ls
instils7811453_instils
intagli845023_intagli
intakes11310943_intakes
intis55121643_int_i_s
intuits7310313_intuits
inwalls1037283_inwalls
jingalls1685333jingalls
jingals1588073jinga_ls
lentils73912973lent_ils
lintels73311163lint_els
lintols7339553lint_ols
mainsails1144853mainsails
maintains1167103maintains
mintages111110513mintages
nails55730403__n_ails
nitrils72810703ni_trils
oxtails1436383_oxtails
pails75833063p___ails
paintable1337243paintable
paintballs1442663paintballs
panties94230933pant_ies
pantile93918483pant_ile
pantiles103617163pant_iles
pantries101817393pantries
partials101911973partials
pastils94416173past_ils
pencils113011773pen_cils
penicils1247863penicils
pensils92811593pen_sils
pentacle1239383pentacle
pentacles1338773pentacles
pentads1039523penta_ds
pentanes10316083pentanes
pentanols1146113pentanols
pentyls1236523pent_yls
pertains102113423pertains
petals84719813p_eta_ls
pibals103813083pi_ba_ls
pickadils1842303pickadils
pietas84516503pieta__s
pieties9419223piet_ies
pigtailed1353493pigtailed
pinangs10267793pin_angs
pinas75434453pin_a__s
pinatas93711503pin_atas
pinball1137933pinba_ll
pineal84817693pinea_l_
pineries102419083pineries
pinitols1046103pinitols
pinkies133818263pin_kies
pinnaces12268863pinnaces
pinnacle12416963pinnacle
pinnacles13276043pinnacles
pinnal84814283pinna_l_
pinnas85315523pinna__s
pinnies93318443pin_nies
pinta75727053pinta___
pintada1096083pinta_da
pintado1096573pinta_do
pintadoes1295253pintadoes
pintano998993pinta_no
pintle83818263pint__le
pintles94118733pint_les
pintoes95117713pint_oes
pintos86021293pint__os
pints75936223pint___s
pintsize1955103pintsize
pinwale1257843pinwa_le
pinwales1367963pinwales
pipals104213643pi_pa_ls
pistil83915073pist_il_
pistols93213983pist_ols
pitas77427673pi_ta__s
pitayas1286263pi_tayas
pitfalls1345373pitfalls
pithily1567033pi_thily
pities83828083pi_t_ies
pittas86014523pitta__s
plantains1147493plantains
pointable1337343pointable
pontil8315463pont_il_
ponytail1344553ponytail_
portals94015563porta_ls
postals93716383posta_ls
prevails1337673prevails
printable1338203printable
punties94520783punt_ies
qintars16268573qinta_rs
quintains18306033quintains
quintals17288003quinta_ls
rattails837133rattails
redtails968003redtails
renails74917263ren_ails
rentals74017483renta_ls
retails74718973_retails
ringtail944723ringtail_
snails64816653_sn_ails
spinals93911863spin_a_ls
spitals93011593spi_ta_ls
sprigtails1382783sprigtails
springtails14112223springtails
tails55634193___tails
tenails73713923ten_ails
tincals93610653tinca_ls
tinfoils1144323tinfoils
uintaite8127353uintaite
uintaites9136333uintaites
unnails738223_unnails
ventail10310453ventail_
vinals94716483vin_a_ls
vintages12118273vintages
vitals94514303vi_ta_ls
wagtails1244443wagtails
whiptails1742903whiptails
wintrily1445373wintrily

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.406440125.6
2DLD Change Limit1461621697.40619735.6
3Display Results1691690.0602816.7
 (SQL Overall)1786911697.87222699.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.