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

125 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
pistoling126849(None) 
pistolling1345351pistolling
pastoring12310852pastoring
pestling111010252pest_ling
pistolier1146382pistolier
bestowing1535803bestowing
bishoping1744283bishoping
bristling1246663brist_ling
bustling112110063bust_ling
castling11311233cast_ling
disabling1337753disabling
discoing12511453disco_ing
disposing1339933disposing
disrobing1347703disrobing
dissolving1545113dissolving
distilling1247793distilling
distorting1239593distorting
disyoking1844993disyoking
dittoing1036263ditto_ing
firstling1334423first_ling
fisting113818123fist__ing
histing113720373hist__ing
hosteling1337893hosteling
hustling12228793hust_ling
intoning9311123_intoning
isling71213883_is__ling
isoline7314013_is_oline
jostling16207123jost_ling
justling16207253just_ling
kitling123313573ki_t_ling
kittling1336063ki_ttling
listening10128953listening
listing84020593list__ing
misatoning1346443misatoning
miscoding1538183miscoding
misdoing1238803misdo_ing
misfiling1537223misfiling
mismoving1745783mismoving
misruling1237493misruling
misstyling1643833misstyling
mistaking1699693mistaking
mistiming1438913mistiming
misting103623383mist__ing
mistitling1346223mistitling
mistuning1237673mistuning
mistyping1744723mistyping
misyoking1944923misyoking
nestling958893nest_ling
paroling113316213p_aroling
pasting103826553past__ing
pasturing1238433pasturing
pestering122315663pestering
pettling1168213p_ettling
photoing1439073photo_ing
picholine1646643picholine
pickling17239203pi_ckling
picolin11310883pi_colin_
picoline12310853pi_coline
picolins1239853pi_colins
picoting1338883pi_coting
picturing1436033picturing
piddling13208953pi_ddling
piffling1745133pi_ffling
piling95025593pi___ling
pilling103722563pi__lling
pillowing1545493pillowing
piloting1139693pi_loting
pindling122110983pi_ndling
pinfolding1743013pinfolding
pinioning1246863pinioning
pishing134314373pis__hing
pisolite10310373pis_olite
pisolith1346553pis_olith
pissing103914803pis__sing
pistol83313333pistol___
pistole92414313pistol__e
pistoled11259593pistol_ed
pistoleer1144313pistoleer
pistolero1163643pistolero
pistoles102514723pistol_es
pistoliers1244583pistoliers
pistolled1255173pistolled
pistols93213983pistol__s
piston83515923pisto__n_
pistons93016373pisto__ns
pitching163411113pi_tching
pithing134014053pi_t_hing
pitting103618873pi_t_ting
pitying132910243pi_t_ying
pivoting1436183pi_voting
poisoning1245903pois_oning
poling93526503p___oling
pooling103219093p__ooling
posting105622243post__ing
postponing1555743postponing
postposing1555023postposing
posturing1238993posturing
prattling1246303prattling
prestoring13310303prestoring
prisoning1237643pris_oning
resoling92916303res_oling
restoking1438193restoking
restoring10314613restoring
restyling1337923restyling
rustling9249983rust_ling
sistering101213753sistering
soling74226823__s_oling
staling83925423__staling
stoking123615593__stoking
stoning83717443__stoning
stooling93113133__stooling
stoping103716623__stoping
storing83921123__storing
stowing113315133__stowing
styling112910653__styling
tiptoeing1242713tiptoeing
titling83715793ti_t_ling
toling73926123___toling
visioning1347063visioning
visoring1238373vis_oring
vittling1236143vi_ttling
whistling1644733whist_ling
wintling12249923wint_ling
wisting113519743wist__ing
witling113215813wi_t_ling

Search took 7 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 Filter1786911486410.406440125.6
2DLD Change Limit1486411256.34323433.9
3Display Results1251250.0502500.0
 (SQL Overall)1786911256.79926282.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.