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

154 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
shippings1727568(None) 
shipping163611251shipping_
shoppings17295071shoppings
whippings20284181whippings
chipping18389792chipping_
clippings16273752clippings
drippings15313902drippings
hipping153915102_hipping_
hoppings16306522_hoppings
lippings13296092_lippings
shielings13237122shielings
shillings13348092shillings
shippens15316802shippen_s
shippons15255662shippon_s
shirrings13245322shirrings
shirtings13276602shirtings
shopping163611292shopping_
sipping123117432s_ipping_
skipping17297602skipping_
slipping133510662slipping_
snipping13308852snipping_
stipplings1582372stipplings
trippings14225722trippings
whipping19328172whipping_
blipping15306803blipping_
cappings15369493_cappings
chapping183710723chapping_
chippies17309753chippi_es
chirping16278863chirping_
chitlings15255903chitlings
chopping183710263chopping_
clipping15349153clipping_
cuppings15336053_cuppings
dipping134014833_dipping_
dripping14278033dripping_
droppings15264503droppings
flipping16307663flipping_
gipping133813123_gipping_
gripping14277543gripping_
happing153817233_happing_
harpings14379773_harpings
helpings14255653_helpings
hidings12349703_hi_dings
hildings13347503_hildings
hiplines13310593_hiplines
hippies142813743_hippi_es
hippiness1635463_hippiness
hissings12556753_hissings
hopping154115273_hopping_
impings12348553__impings
kipping163311873_kipping_
lipping123016073_lipping_
mappings15296413_mappings
nipping123412873_nipping_
pipings12338253_pi_pings
pipping113414743_pipping_
pippins10319753_pippin_s
quipping2234843quipping_
reshipping1843793reshipping_
ripping123315743_ripping_
sailings93513253sai_lings
samplings1435553samplings
saplings11269803s_aplings
sapping123519313s_apping_
schillings16243273schillings
scrapings14255173scrapings
seisings9398523sei_sings
seizings18326473sei_zings
shadings13327433sh_adings
shaftings16224183shaftings
shaping133116183sh_aping_
sharping143011373sharping_
shavings15356333sh_avings
shealings13317563shealings
shearings13337563shearings
sheetings13256713sheetings
shelvings16283823shelvings
shieling123512403shieling_
shifting152910383shifting_
shilingi1233843shi_lingi
shilling123315383shilling_
shimming16278253shimming_
shindigs13284203shindi_gs
shining113816523shi_ning_
shinning123211023shinning_
shipments16254703shipments
shippen14298863shippen__
shippers153012313shipp_ers
shippon14285803shippon__
shipsides1544883shipsides
shirking163210473shirking_
shirring122910443shirring_
shirting123213613shirting_
shitting123212663shitting_
shlepping1733393shlepping_
shootings13266063shootings
shorings12269483sh_orings
showings15246883sh_owings
showrings1644063showrings
shrimping1734063shrimping_
shuckings19273853shuckings
siblings11108123s_iblings
sidings94011463s_i_dings
siftings12236583s_iftings
siping94220633s_i_ping_
sittings9339733s_ittings
sizings17378013s_i_zings
skiings12295733ski__ings
skillings14246133skillings
skimmings18243263skimmings
skimping17306243skimping_
skiorings14243793skiorings
skirtings14274563skirtings
slapping133510833slapping_
sleepings12335883sleepings
sliping103314413sli_ping_
slopping133811423slopping_
snapping13349653snapping_
sniping103712053sni_ping_
sopping123917203s_opping_
spilings11308813spi_lings
spinnings12294853spinnings
springs104415923s__prings
stepping13329073stepping_
stippling1475173stippling_
stirrings10224693stirrings
stopping133611413stopping_
strappings1543353strappings
stripings12215203stripings
striplings1344183striplings
stripping1436493stripping_
suitings9288953sui_tings
supping123814533s_upping_
swapping16348673swapping_
sweepings15345633sweepings
swimmings17263153swimmings
swingings14275053swingings
swiping13319823swi_ping_
swopping16377963swopping_
tappings13267713_tappings
thinkings17255053thinkings
tipping122814973_tipping_
toppings13286423_toppings
trappings14265753trappings
tripping133210923tripping_
unshipping1843203unshipping_
uppings12257123__uppings
whapping19317113whapping_
whitings15287063whi_tings
whopping19357373whopping_
whupping19345243whupping_
wrappings17253713wrappings
yipping152710683_yipping_
zipping212910573_zipping_

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.1731032896.0
2DLD Change Limit1486411546.45323034.4
3Display Results1541540.0801925.0
 (SQL Overall)1786911546.70626646.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.