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

212 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
uppiling133585(None) 
unpiling1139751unpiling
piling95025592__piling
speiling113612972speiling
spiling102919702_spiling
spoiling112911552spoiling
suppling1359042supp_ling
umpiring1336092umpiring
upboiling1444622upboiling
upcoiling1444792upcoiling
updiving1534222updiving
upfling1337092u_pfling
upping114013702upp__ing
uprising1138952uprising
upsizing2035412upsizing
uptilting1234712uptilting
ailing74331013__ailing
anviling1239743anviling
appalling1444923appalling
appealing1446493appealing
applying1634653applying
apposing1337403apposing
apprising1447963apprising
apprizing2347193apprizing
aspiring1138873aspiring
availing1267283availing
bailing103723523_bailing
boiling103819673_boiling
brailing113514793brailing
broiling113112013broiling
caviling14310113caviling
ceiling103416723_ceiling
coiling103723453_coiling
compiling1637763compiling
coppicing1845403coppicing
cupeling1338863cupeling
cupelling1436283cupelling
cupping144312383cupp__ing
dappling1436843dappling
defiling132812463defiling
deviling1311812853deviling
dumpling14217893dump_ling
dupping133711043dupp__ing
emailing113010043emailing
empaling1338363empaling
ensiling9410723ensiling
exiling15311083_exiling
expiring1836253expiring
failing113521333_failing
filing103823763__filing
flailing12298923flailing
foiling113317653_foiling
guiling93214213_guiling
hailing113820693_hailing
heiling113616363_heiling
hoppling16206763hoppling
impaling1338253impaling
jailing153415843_jailing
mailing102923343_mailing
moiling103417663_moiling
nailing83419963_nailing
oiling74925313__oiling
opining10311743_opining
oppilant1246023oppilant
oppilating1544853oppilating
opposing1336383opposing
outwiling1337463outwiling
paiking143814813_paiking
paining103920243_paining
pairing103716733_pairing
paling93530133__paling
palling104024483_palling
parling103823763_parling
pealing104123203_pealing
peeling102919873_peeling
peining104619153_peining
peising103416763_peising
periling11316863periling
pieing93917653__pieing
piing85218833__pi_ing
piking133719643__piking
pilings103313613__pilings
pilling103722563_pilling
pining93726533__pining
piping114017453__piping
pipping113414743_pipping
poising103617103_poising
poling93526503__poling
polling102920383_polling
pooling103219093_pooling
poppling12227323poppling
pricing123417343_pricing
priding113317543_priding
prilling113413413_prilling
priming123417373_priming
prising103321453_prising
prizing193514683_prizing
puddling13218033puddling
puling93621403__puling
pulling103821073_pulling
pumicing1535843pumicing
pungling12228663pungling
pupating1337683pupating
pupping114412503pup_ping
purfling1467763purfling
purling103620293_purling
purpling1368543purpling
puzzling19225393puzzling
quailing1838403quailing
railing83325643_railing
rappeling1435963rappeling
refiling123116533refiling
reoiling93217213reoiling
repining114116593repining
resiling93520173resiling
retiling93319483retiling
reviling122917213reviling
riling74227973__riling
rippling13197573rippling
roiling83220453_roiling
rumpling13178763rump_ling
sailing83927373_sailing
sapling103217863sap_ling
smiling103915443_smiling
snailing92912973snailing
soiling83422323_soiling
sopiting11310763sopiting
spalling113213463spalling
sparling112714533sparling
speeling112713123speeling
speiring113711263speiring
spelling113315233spelling
spicing123914533_spicing
spieling113212523spieling
spiking144312883_spiking
spilings11308813_spilings
spilling113113943spilling
spiring103918183_spiring
spiting103917623_spiting
splicing1338963splicing
splining11310773splining
spooling113212563spooling
supping123814533supp__ing
supplying1774043supplying
supposing1445843supposing
suspiring1245703suspiring
tailing82923103_tailing
tiling73426553__tiling
tippling13196703tippling
toiling83219023_toiling
toppling13197353toppling
trailing92916093trailing
tripling112712553tripling
tupping123411663tupp__ing
umping114815333ump__ing
unbaling11310683unbaling
uncoiling1238993uncoiling
unfailing1337453unfailing
unfixing1935683unfixing
ungiving1346333ungiving
uniting8315823u_niting
unliving1248193unliving
unmixing1835543unmixing
unnailing1037023unnailing
unpaying1456943unpaying
unpicking1834883unpicking
unpinning1245623unpinning
unpitying1544043unpitying
unsling8313643u_nsling
unsmiling1256873unsmiling
untieing938863untieing
untiring9312003untiring
unveiling1337723unveiling
unwilling1337163unwilling
upbinding1544303upbinding
upbuilding1642073upbuilding
upcoming1535173upcoming
upcurling1453493upcurling
updating1236593updating
updrying1534013updrying
upending12258133upending
upflings1433733u_pflings
upflung1342213u_pflung
upfolding1642943upfolding
upgazing2133313upgazing
upgirding1442373upgirding
upgoing1135353u_pgoing
upholding1643373upholding
uplifting1534963uplifting
uplink12388713u_p_link
uplinking1634623uplinking
uppile10178503uppil__e
uppiled12216593uppil_ed
uppiles11208263uppil_es
uppings12257123upp__ings
upraising1237263upraising
uprating11311113uprating
uprisings1243343uprisings
upscaling1444653upscaling
upsilon943583upsilon_
upsilons1043173upsilons
upspring1335703upspring
upswing1335593u_pswing
uptalking1643353uptalking
upwelling1535233upwelling
urping93914053urp__ing
vailing113817943_vailing
veiling113615293_veiling
wailing113620903_wailing
whiling143511743_whiling
wiling103024293__wiling
yuppifying2442443yuppifying

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622126.11023921.8
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.35928100.5
 
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.