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

194 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
piaffing173392(None) 
baffing164011602_baffing
biffing163510012bi_ffing
chaffing2036322chaffing
daffing15369732_daffing
gaffing15379732_gaffing
miffing16298402mi_ffing
naffing14359032_naffing
piffling1745132piffling
puffing162910942p_uffing
quaffing2434352quaffing
riffing144011272ri_ffing
spiffing17237082spi_ffing
staffing15247492staffing
tiffing14339382ti_ffing
waffing173710242_waffing
yaffing17337822_yaffing
affine12310503__affine
baffling1756053_baffling
barfing134615093_barfing
biasing103512453bia_sing
biassing11307263biassing
biffin14369103bi_ffin_
biffins15358533bi_ffins
bluffing17275493bluffing
boffing16339983_boffing
buffing163411393_buffing
chafing163911493cha_fing
cheffing2034463cheffing
chuffing2055043chuffing
coffing163811253_coffing
coiffing1755933coiffing
crafting143710173crafting
cuffing163210253_cuffing
dialing94318173dia_ling
dialling10310783dialling
doffing15357793_doffing
drafting13339403drafting
dwarfing1633613dwarfing
feoffing1432963feoffing
fifing134212343fi__fing
fluffing14275413fluffing
gifting123810893gi_fting
grafting13319623grafting
gruffing1635273gruffing
hafting144014173_hafting
huffing17278833_huffing
leafing113313583lea_fing
liaising937913liaising
lifting113313273li_fting
loafing11319793loa_fing
luffing143310103_luffing
miaouing1134893miaouing
miaowing1434593miaowing
miauling1137343miauling
muffing163210403_muffing
offing13368643__offing
opiating11410093opia_ting
pacing114522753p_a_cing
packing164420723p_acking
padding123412513p_adding
paging104020403p_a_ging
paiking143814813p_aiking
paining103920243p_aining
painting113614423painting
pairing103716733p_airing
paling93530133p_a_ling
palling104024483p_alling
palming123914013p_alming
palping124112873p_alping
panging113319113p_anging
panning104019393p_anning
panting104025423p_anting
paraffin1644903paraffin_
paraffine1744673paraffine
paraffins1744643paraffins
parging113318603p_arging
paring94236493p_a_ring
parking143423043p_arking
parling103823763p_arling
parring103222063p_arring
parsing103819553p_arsing
parting103527383p_arting
pashing135120513p_ashing
passing104318423p_assing
pasting103826553p_asting
patting103722343p_atting
pausing103912813p_ausing
paving124519743p_a_ving
pawing124519553p_a_wing
pawning134711413p_awning
paying123722163p_a_ying
peaching163613643peaching
peacing124117073pea_cing
peaking144317693pea_king
pealing104123203pea_ling
pearling11912013pearling
pharming16248143pharming
phasing133211673pha_sing
piaffe1494913piaff__e
piaffed1693753piaff_ed
piaffer15104443piaff_er
piaffers16114203piaffers
piaffes15115053piaff_es
picking163418333pi_cking
pickling17239203pickling
picoting1338883picoting
piddling13208953piddling
piecing12410453pi_ecing
pieing93917653pi__eing
piercing1346663piercing
pigging123614673pi_gging
piing85218833pi___ing
piking133719643pi__king
pilfering1536393pilfering
piling95025593pi__ling
pilling103722563pi_lling
piloting1139693piloting
pimping143812123pi_mping
pinching163711053pinching
pindling122110983pindling
pinging113419553pi_nging
pining93726533pi__ning
pinking143918943pi_nking
pinning103417853pi_nning
piping114017453pi__ping
pipping113414743pi_pping
piquing1935873pi_quing
pirating11314513pirating
pishing134314373pi_shing
pissing103914803pi_ssing
pitching163411113pitching
pithing134014053pi_thing
pitting103618873pi_tting
pitying132910243pi_tying
pivoting1436183pivoting
placing123815283pla_cing
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pla_ning
planking153513013planking
planning113610223planning
planting113515383planting
plashing143311063plashing
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
poaching163510833poaching
praising113214563praising
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453pra_ting
prawning1446963prawning
praying133717323pra_ying
proofing1439313proofing
psalming1375473psalming
puffin141149003p_uffin_
puffins15278913p_uffins
purfling1467763purfling
raffling1567063_raffling
rafting113815753_rafting
reffing143712173_reffing
riffling1556113riffling
rifling112815013ri_fling
rifting113515003ri_fting
ruffing143210843_ruffing
scarfing14309713scarfing
sclaffing1843363sclaffing
scoffing17275943scoffing
scuffing17287113scuffing
shafting15278683shafting
sifting113014593si_fting
sluffing15247303sluffing
snaffling1643763snaffling
snafuing1235083snafuing
snarfing12358663snarfing
sniffing15227453sniffing
snuffing15256803snuffing
spiffying2142753spiffying
stiffing15248703stiffing
stuffing15247843stuffing
tiffin12327933ti_ffin_
tiffins13327983ti_ffins
upwafting1842063upwafting
vialing113614163via_ling
vialling1237223vialling
waffling1845423_waffling
wafting143911663_wafting
waifing142910893_waifing
wharfing1834683wharfing
whiffing2134703whiffing
wifing133513393wi__fing

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 Limit1461621946.95321021.4
3Display Results1941940.0932086.0
 (SQL Overall)1786911947.46923924.4
 
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.